I'm trying out two Delphi wrappers. One is the SQLite for Delphi project here:
http://sourceforge.net/projects/sqlite4delphi the other is the much simpler wrapper here (warning: this links to the actual zip file): http://myhtpc.net/sqlite/sqlite-delphi.zip I actually want to use the simpler wrapper but I can't work out a performance issue. On Win XP the 2 wrappers have similar perf. On Windows 98 (ugh) the SQLite for Delphi project populates a dataset approximates 3 times faster (not a small difference). I thought at first this was because the simple wrapper uses sqlite_get_table(). So I changed it to use a callback instead. I then tuned the callback in various ways. By using a profiler, I can see that my implementation of the callback is about 4 times quicker than the other (not surprising, as it doesn't implement a fully-fledged Delphi dataset). Yet overall it remains 3 times slower. All the profiler tells me is that the call to sqlite_exec takes 3 times longer (I haven't tried to profile the Sqlite dll as yet). What I can't work out is why. The same database is used. The same Sqlite dll is used. The same pragmas are executed. The compiler options are identical (unless I've missed a directive lurking in the code somewhere). Just wondering what I'm missing? Tim --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
