[sqlite] sqlite3_release_memory when SQLITE_THREADSAFE=0

2015-03-16 Thread Xavier Snelgrove
Hi Simon, Well in my case the linked threadsafe.html documentation won't be helpful, because it looks like at runtime I can only downgrade as far as multi-thread mode, not single-thread mode, and it's in single-thread mode where I'm really seeing a significant performance advantage. I think the p

[sqlite] sqlite3_release_memory when SQLITE_THREADSAFE=0

2015-03-15 Thread Simon Slavin
On 13 Mar 2015, at 6:26pm, Xavier Snelgrove wrote: > Are there any other options here? Does the last section of help you in your situation ? Alternatively you might be able to use to manually maintain

[sqlite] sqlite3_release_memory when SQLITE_THREADSAFE=0

2015-03-13 Thread Xavier Snelgrove
Hello, I'm using SQLite extensively (thanks for the great tool!) in an application where it's almost exclusively accessed on a single thread. I have found that the SQLITE_THREADSAFE=0 compile-time option gives us a 3% improvement in overall performance by removing mutex overhead. However: there a