Fastest DataSet scenarion

[krshin]

Hello,

I need to have one dataset (UniQuery, UniTable, ...) which will fetch all data from database, and just use for searching (Locate, FindNearest, ...) no return data, no updates, no nothing like that. But! I need fastest way to fetch data into which dataset component i which is bes and fastest search criteria (for example I have 5 fields name, office, street, city and zip) and user can enter any of data (for example 'NewYork') my procedure check is this name if not is this office if not is this city and bingo if it find that it is a city to position dataset on first match record and sort by that field.
Dataset should have in some cases more than 25.000 records

Thanks in advance...

[azyk]

To provide the fastest data fetching from the database to the dataset and navigation through the dataset using UniDAC, please see our recommendations in the article: http://www.devart.com/unidac/docs/index ... rmance.htm . If you have any specific issues after reading the article, please ask them - and we will answer you.