Devart Forums

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.

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.