Fastest way to locate records in disconnected mode

[michaschumann]

For my current project I use some TTables I load from a database in disconnected mode and want to feed a virtual grid from these datasets. I need to locate Records in theese datasets with different criteria. So I wonder what is the fastest way to locate records in the disconnected table objects. I now locate but perhaps there is something much more clever and much faster.

[ViktorV]

For local record search you can use methods Locate and LocateEx. See the IBDAC help about these methods:https://www.devart.com/ibdac/docs/?deva ... locate.htm, https://www.devart.com/ibdac/docs/?deva ... cateex.htm To provide the fastest data fetching from the database to the dataset and navigation through the dataset using IBDAC, please see our recommendations in the article: https://www.devart.com/ibdac/docs/?incr ... rmance.htm. If you have any specific issues after reading the article, please ask them - and we will answer you.