Hi,
I have an Access database with 20K read-only records.
I have 12 columns, I displayed 4. 3 are in html which one is an image.
I only display 25 lines.
I have to change often indexes and research to in these fields.
Before I used a TADOTable and it was faster.
What advise would you give to optimize the changes of indexes and searches because it's now very slow.
Regards
Stéf
Did you set grid.PageMode = true and grid.DataSetType = dtNonSequenced and implemented OnGetRecordCount in a proper way?