Before I do database, link components are ADOConnection + ADOQuery + datasource fix, the need to do a larger amount of data processing program, such as need a display 200000 records in the DBgrid, reoccupy previous methods, one is to read slowly, but drag the scrollbar DBgrid very card, consult everybody, what should I use to connect components?

CodePudding user response:

DisableControls useful?

CodePudding user response:

Paging display

Speed is faster

CodePudding user response:

Don't need to use ADOQuery, use TClientDataSet.Com mandText to obtain a local cache the query results,

CodePudding user response:

Use DBGrid is for the sake of with database synchronization data? I were StringGrid, also does not require the synchronization, the data read out directly credited StringGrid, then, 200000 data read is to spend some time, can display properly, but after reading it scroll also no pressure, if you need any sort of what, also was done in memory, has nothing to do with the database, but if you need to modify the data, take the time to find the corresponding record estimation is little not, consider the building Lord,

CodePudding user response:

reference 4 floor xinhunter response:

use DBGrid to synchronize data with database? I were StringGrid, also does not require the synchronization, the data read out directly credited StringGrid, then, 200000 data read is to spend some time, can display properly, but after reading it scroll also no pressure, if you need any sort of what, also was done in memory, has nothing to do with the database, but if you need to modify the data, take the time to find the corresponding record estimation is little not, consider the building Lord,

Thank you for your reply

CodePudding user response:

Such as the need in the DBgrid one show 200000 records
Are generally use virtual list methods shows that if it is easier with devexpress corresponding components,