Refresh the data if a grid contains thousands of rows

ibdac2pro · Post by **ibdac2pro** » Thu 26 Jun 2008 11:06

Hi,

I have an application written in Delphi 7 with an Interbase 2007 database.

The application runs in a multi-user environment and I was wondering what is the most efficient way to refresh my view of the data in order to reflect changes made by other users.

I have been using the Refresh method of TIBCQuery to refresh the data, which is fine for recordsets containing only a few rows of data, but my application contains several grids (Developer Express TcxGrid components) which could potentially contain thousands of rows.

Using Refresh on these grids causes an unacceptable delay before the data is displayed.

Is there a more efficient way to refresh the data if a grid contains thousands of rows?

Many thanks,

Michael.

Challenger · Post by **Challenger** » Thu 26 Jun 2008 13:24

No, IBDAC does not provide functionality to perform full refresh more efficiently.

bl9876 · Post by **bl9876** » Sun 20 Jul 2008 17:02

Hi Michael,

please have a look at your grids. "GridMode" is a strong feature. There you can define whether and how many rows should be loaded. This will dramatically reduce loading time.

In case you are using Grid Summary Columns, please review DevExpress´s forum as there are plenty of ways using GirdMode and Summaries.

Kindest regards
Bjorn