The "PRAGMA optimize" looks interesting.
- Can using "PRAGMA optimize" in one thread create a situation where
"BEGIN IMMEDIATE TRANSACTION" in another thread fails? (The threads are
using different connections)
- Is there any risk of "optimization fighting" if several threads are
using the same database but with different work load? (i.e. can an
optimization replace another optimization, or do they just accumulate?)
Unrelated:
Is there any public information about feature/enhancement ideas in early
stages? The actual development can be seen in the commit history, but I
mean a more general overview when you discuss & plan for future
enhancements. Just out of curiosity.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users