[fpc-pascal] sqldb how to find a record fast with primary key

[michael.vancanneyt at wisa.be]

On Fri, 21 Oct 2011, Martin Schreiber wrote:

> On Friday 21 October 2011 16.30:18 michael.vancanneyt at wisa.be wrote:
>> On Fri, 21 Oct 2011, Felipe Monteiro de Carvalho wrote:
>>> Ping,
>>>
>>> No sqldb specific answers on this one? I did some googling and also
>>> searched for TPrimaryKey or LocalIndex in sqldb without results ... =(
>>
>> To my knowledge there is no fast search/locate in sqldb.
>> Maybe we should have a look at Martin Schreibers' implementation.
>>
> Most code is in lib/common/db/msebufdataset.pas. Lookup buffers are in
> lib/common/db/mselookupbuffer.pas. Heavy stuff. ;-)

Well, sqldb has the indexes. It's just an additional index routine.

Michael.