Hello,
I was doing some performance tests and made a test on DBAdvGrid. I dropped three DB TTables, connected the first to the second via Master/Detail. Also connected the second with the third via another Master/Detail.
I dropped three DBAdvGrid in a form and connected them to the three tables. Opened the tables and scrolled the 30 records of the the first table automatically. It took 27 seconds to complete the job.
I replaced the DBGrids with three DBAdvGrid and did the same job and this time it took 43 seconds. What can I do in order to improve the performance ?
Many thanks
Alberto
Did you read the notes on performance in the DBAdvGrid PDF developers guide?
The only note I could find is the PageMode=True but this is set by default. I suppose there is something else but I was not able to find it.
Page 6:
Some dataset implementations have a slow MoveBy operation that causes in turn that TDBAdvGrid is
slow. A solution for this is to use a SQL ‘SELECT COUNT’ operation to supply the number of rows in
the dataset to TDBAdvGrid via the event OnGetRecordCount. Most datasets have a fast
implementation of the ‘SELECT COUNT’ command. With TDBAdvGrid.PageMode set to true and
OnGetRecordCount implemented via a ‘SELECT COUNT’. The sample application BDERecordCount in
the TDBAdvGrid samples distribution shows how this can be done.