Confirm
595
edits
Changes
m
→More Tips
* Maintain your DB with [https://sqlite.org/lang_vacuum.html VACUUMs] during Firefox version upgrades or during idle times. Run [http://www.sqlite.org/lang_analyze.html ANALYZE] periodically if necessary
** You should have a vacuum plan from the get-go. '''This is a requirement for all new code'''.
* If working on the same data from multiple connections, consider using an unshared memory cache, to avoid memory contention. This will improve concurrency.
** Though, it will also multiply the memory cache per the number of connection, so it's a memory/performance choice you should do carefully
