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

michael.vancanneyt at wisa.be michael.vancanneyt at wisa.be
Fri Oct 21 17:14:01 CEST 2011

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.


More information about the fpc-pascal mailing list