Changes

Jump to: navigation, search

Performance/Avoid SQLite In Your Next Firefox Feature

249 bytes added, 07:45, 8 April 2014
m
Memory Usage
* By default, our SQLite wrapper uses a [http://hg.mozilla.org/mozilla-central/file/444714c3820a/storage/src/mozStorageConnection.cpp#l48 max of 2MB memory cache per connection].
** This cache size may be too large for Fennec and B2G, especially if there are multiple connections. The cache size should be adjusted with [[#Important Pragmas|PRAGMAs]]
** Queries unable to use an index will use SCAN TABLE to go through all of the rows, this will quickly grow the page memory cache to the maximum value, this space is never called back until PRAGMA shrink_memory is used, or the connection is closed.
=== CPU Usage ===
Confirm
595
edits

Navigation menu