[fpc-pascal] sqldb how to find a record fast with primary key
mse00000 at gmail.com
Fri Oct 21 17:59:00 CEST 2011
On Friday 21 October 2011 17.41:56 Felipe Monteiro de Carvalho wrote:
> I get the value of the primary key of the table from the request, so I
> though that because it is the primary key I would be able to quickly
> jump to it. But it seams that not? From what I understood the
> solutions are first going through the entire table and indexing it to
> make future lookups faster. But this does not seam to use the fact
> that my field is the primary key.
Can't you do the lookup in the DB server by a SQL join for example?
More information about the fpc-pascal