rv.gauth...@free.fr wrote: > 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.
Because then you get an automatic transaction for every query. > I tried also to do a unique BEGIN TRANSACTION after opening the database. > This fixes the timing issue, but my memory increases constantly. Probably just the cache. > Is there a way (pragma, compile flags, ...) to gain these 14 ms for the first > query ? Try PRAGMA locking_mode = EXCLUSIVE: http://www.sqlite.org/pragma.html#pragma_locking_mode Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
