mozilla

Revision 60906 of Performance

  • Revision slug: Storage/Performance
  • Revision title: Performance
  • Revision id: 60906
  • Created:
  • Creator: BrettWilson
  • Is current revision? No
  • Comment

Revision Content

Introduction

mozStorage uses sqlite as the database backend. It has generally good performance for a small embedded database. However, many things case various database operations to be slow.

Queries

Many times careful reordering of the SQL statement or creating the proper indices can give much better performance. See the

See the sqlite optimizer overview on the sqlite web site for information on how sqlite uses indices and executes statements.

You might also want to try to analyze your sql commands to see if they are using the indices you expect.


Caching

Disk writes

Revision Source

<h2 name="Introduction"> Introduction </h2>
<p>mozStorage uses sqlite as the database backend. It has generally good performance for a small embedded database. However, many things case various database operations to be slow.
</p>
<h2 name="Queries"> Queries </h2>
<p>Many times careful reordering of the SQL statement or creating the proper indices can give much better performance. See the 
</p><p>See the <a class="external" href="http://www.sqlite.org/optoverview.html">sqlite optimizer overview</a> on the sqlite web site for information on how sqlite uses indices and executes statements.
</p><p>You might also want to try to <a class="external" href="http://www.sqlite.org/lang_analyze.html">analyze</a> your sql commands to see if they are using the indices you expect.
</p><p><br>
</p>
<h2 name="Caching"> Caching </h2>
<h2 name="Disk_writes"> Disk writes </h2>
Revert to this revision