TDBAdvGrid is very slow when using filters

VCL TMS VCL UI Pack
1

I'm using Delphi 2010, TDBAdvGrid version 2.5.1.9, ADOQuery, SQL database.
I have:
DataSetType = dtSequenced
FilterDropDown.AutoSize = True
FilterEdit.Enabled = True
FilterEdit.CaseSensitive = False
Pagemode=False
SortSettings.Show = True
OnDrawCell is implemented
What can be the reason that filtering and sorting is so very slow.
A dataset of 3000 records and 2 text-filters (contains)
Sorting with filtered record cost about 9 sec and changing a filter field is also very slow

What options can I use to make it faster?

2

Try to toggle the setting TDBAdvGrid.DataSetType and/or set TDBAdvGrid.PageMode = true

3

With PageMode = True and filters I got the wrong result.
DataSetType didn't change much.
I discovered the big time consumer which is:
FilterDropDownAuto = True
FilterDropDownCheck = True

4

This topic was automatically closed 60 minutes after the last reply. New replies are no longer allowed.

5

Can you check if it helps to implement the grid.OnGetRecordCount event as mentioned in the dev. guide on page 6:

to accelerate the operation in case your database has a slow MovBy() implementation?