[sqlite] Soft heap limit enforcement performance

2007-10-30 Thread patters
We rely on the SQLite memory management to enforce the memory usage in our application (running on Windows CE). This has worked quite well for us, but have found that when we hit the limit, in some circumstances, performance drops significantly. Looking into the internals of SQLite, it seems

[sqlite] Performance issues in 3.5.1 (Windows)

2007-10-06 Thread patters
We've been using 3.4.2 for a while now but on drh's recommendation we've now upgraded to version 3.5.1, and have found performance to be a magnitude slower than 3.4.2. We are running on Windows CE, with memory management and threadsafe on (though disabling these does not fix the problem). We

[sqlite] Bug: Database connection closed on different thread

2007-10-02 Thread patters
Greetings, We ran into a bug that's not documented behavior: closing a connection that was created in a different thread (where thread A calls sqlite3_open[16], "hands off" the connection to thread B, and thread B calls sqlite3_close). The documentation (http://www.sqlite.org/faq.html#q6) says