Devart Forums

Hi;

im porting an app that has 2 sections on its input screens.

the first section is a Grid (CRDBgrid) that shows all the records on the table and it has search, filter and other features.

the second section is the input screen, with all the edits and validations.

The original app never had to manage many records, so, the speed was fine; but now i have to deal with thousands of records and some of the users will access the app remotely.
So, speed is a real concern, right now, i noticed some delay from the time i choose the option on the main menu and the time the screens are displayed with the grid totally populated; and this is on development with me as the only user!!!

I want to keep the functionality of the grid and avoid big delays for the users.

Any sugestion will be greatly apreciated.

TIA

First of all you should determine what is the reason of this slowness: server, network, or client.

Probably setting the FetchAll property to False of your TMyQuery/TMyTable will speed up your application. In this case you should use the server side ordering, as the client ordering leads all records to be fetched to the client in spite of the value of FetchAll. For more information see description of the FetchAll property in the MyDAC help.
Also the "Increasing performance" topic in the MyDAC help should be useful for you.