Better way of getting a table record?

[cyprus106]

As of right now I'm using a SQLDataSet, DataSetProvider and ClientDataSet to grab a SQL table I've got. The table, however, is about 500,000 records, and any time I try to load it with a good old fashioned CommandType = ctTable, it locks down. I have been using a query, "Select * from... WHERE..." and that's been working alright, but now I've got a problem.

The user will be scrolling through data quickly, and I need some record data to come quicker than the 5 seconds it takes to run through all 500K records to find just one. Any suggestions?

Cyprus

 

[2ffat]

Is there any way to filter the data the users needs. Instead of pulling in all 500,000 records, do they only need 50,000? Also, are you setting the query's prepared property to true?


James P. Cottingham
-----------------------------------------
[sup]I'm number 1,229!
I'm number 1,229![/sup]