Hi,
I am working on an embedded application using SQLite.

My lookaside configuration:
      sqlite3_db_config(mydbhandle,
                  SQLITE_DBCONFIG_LOOKASIDE,
                  0,
  64,
                  128);

After doing some profiling, I saw that sqlite3DbMallocRaw does not allocate 
from the lookaside
buffer pool even when the sizes match.
The reason is, that all available lookaside places are used for prepared 
statements during application
startup.
For my understanding, this should not!

I added a simply possibility for disabling the allocation from the lookaside 
pool temporally.
This is controlled by my application during static statement preparation
and enabled afterwards using this added db_config call:
sqlite3_db_config((sqlite3*) db, SQLITE_DBCONFIG_DISABLE_LOOKASIDE, 1);

This small change, keeps the lookaside pool mostly unused, and it is available 
to serve many small
allocations during normal operation.

My Question:
Is there a way for disabling the use of lookaside buffers for prepared 
statement handles?

Regards

Maik Scholz



_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to