I am wondering what the best (read: fastest) way is to locate a record in a resultset of a Tquery SQL statement. Until now i'm using TQuery.Locate and if i'm right that is the only statement that ...

I want to read the entire contents of a table into memory, as quickly as possible. I am using Nexus database, but there might be some techniques I could use that are applicable to all database type...