There are a number of good changes here!
- Improved query planner:
- Through better use of statistics
- Compile time option enables Analyze to better handle the index histograms
- Additionally it was just plain improved as well!
- Recursive triggers
- Delete triggers fire during a REPLACE/MERGE
- More precise use of caching approaches with the
- Shared Cache – basically cache the results within the application rather can on each thread. Now configurable on a per-thread basis rather than global.
- Private – The old way
Well done to the SQLite team! Good stuff
More details can be found [SQLite Release 3.6.18 On 2009 Sep 11 (3.6.18)]