Confirmed users
595
edits
Performance/Avoid SQLite In Your Next Firefox Feature: Difference between revisions
Jump to navigation
Jump to search
m
Performance/Avoid SQLite In Your Next Firefox Feature (view source)
Revision as of 08:13, 8 April 2014
, 8 April 2014→More Tips
m (→More Tips) |
m (→More Tips) |
||
| Line 114: | Line 114: | ||
* 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 | * 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'''. | ** 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. | * If working on the same data from multiple connections, consider using an unshared [http://www.sqlite.org/sharedcache.html 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 | ** Though, it will also multiply the memory cache per the number of connection, so it's a memory/performance choice you should do carefully | ||