Hi all,
we are using sqlite3 on an embedded application.
The database is opened in read only mode and can't be modified by the
application.
I noticed that the first SELECT statement after a BEGIN TRANSACTION
takes at least 14 ms.
All subsequent queries in the same transaction are taking near 0 ms.
If I omit the BEGIN TRANSACTION, all queries are taking at least 14 ms.
I tried also to do a unique BEGIN TRANSACTION after opening the
database. This fixes the timing issue, but my memory increases
constantly.
Is there a way (pragma, compile flags, ...) to gain these 14 ms for the
first query ?
Thanks.
Hervé Gauthier.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users