I previously asked a similar question - apparently it was not clear.

My table has 100K records and in both cases below dbStartup='filter' is used;
What interests me is the time taken for the filter screen to appear and not the actual running of the query/report.

Case 1: The DbSQL sql statement has no "order by" clause - the filter screen appears after 15-20 seconds

Case 2: The DbSQL sql statement has an "order by" clause - the filter screen does not appear at all, as the request times out after 2 minutes or so.

Regarding the above observations, my questions are:
1. why does the "order by" affect the speed of appearance of the ASP-db filter screen?
2. shouldn't the filter screen come up a lot faster than 15 seconds (as it indeed does for tables with small populations)

Thanks in advance