Re: [sqlite] Not getting the speed I think is possoble. Basic select statment slow?

[Bert Verhees]

Chris Schirlinger wrote:
Tried to compile your wrapper this morning with no luck
The code seems to be written with Delphi 7 or higher? We are still 
using delphi 6 which doesn't have the SysUtils data structure 
TFormatSettings, and the functions FormatDateTime have different 
declarations (only 2 paramaters)

Those where the only issues I could see at a glacne, may try and hack 
that out at a later date when I get more time
 

Did you try www.aducom.com/sqlite, you can create it dynamically in your 
code or use it as  VCL-component.
It also works in Delphi6

Use the Database component and the Query component, you get a 
tdataset-alike resultset.

Bert Verhees
 

out of curiocity, can you give a try to my delphi wrappers? http://www.sqlite.org/contrib  
(not Tdataset replacement, though, but they should be quite fast for this reason. also try the "serverCursor" setting, which allows you to step thorugh the result set one at a time, meaning there is no double-buffering required:

rs:=db.createStatement;
rs.serverCursor:=true;
rs.open....
while not rs.eof do..
let me know how they fare speed-wise, as I have not tested any other wrappers..