Hi,

I'm developing an application that uses a grid for the display and manipulation of the data. It is designed to offer flexible filtering and sorting of the data.

I first started out trying filters. I made sure that the FILTER was potentially optimized, but at one point I waited 20 minutes for it to come back with 2 records (it was a simple filter on a specific field for a specific criteria and there was an index on that field). I don't know if it has anything to do with the fact that I initially start with all of the records displayed in the grid. Even going back from the filter to no filter took forever for the grid to redisplay.

Then I tried to utilize SQL queries to build the data. I tested some queries including the initial "all" query from the command prompt and all were very fast. However, when I do this, the grid get's blanked out because the cursor is temporarily closed when doing a new query. So, I thought I'd just build the grid back on the fly, but the AddColumn() method is taking about 4 minutes per column (24 columns, but only testing with 6). On smaller data sets, I've just kept the cursor open, zapped it and appended in the new records, but the table is going to end up with close to 1 million records in it, and my current data set is about 250,000 records so I don't think that is an option.

I know that this is possible, but I'm just not getting it. Any ideas or insight would be appreciated.

TIA,

Rod Lewis