Because the DB table has 100K records I use dbStart="filter" so that I can filter before presenting the results in the grid.

My questions:
1. It seems (by comparing with sparsely populated tables) that the speed at which the filter is raised depends on the number of records in the DB table.
Why does this happen?

2. Are there any other suggestions/approaches for managing the number of
records returned?

Thanks in advance.