Devart Forums

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.

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

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