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

Martin Schreiber mse00000 at gmail.com
Fri Oct 21 16:50:20 CEST 2011


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. ;-)

Martin



More information about the fpc-pascal mailing list