1. Introduction

1.1. About this FAQ

This FAQ is an incomplete summary of my experiences with speed-optimizing an application that uses the SQLite library. It will be of most use to people who are already familiar with using SQLite. Feel free to send any questions and comments.

It is released under the terms of the SQLite license :)

** The author disclaims copyright to this material.
** In place of a legal notice, here is a blessing:
**
**    May you do good and not evil.
**    May you find forgiveness for yourself and forgive others.
**    May you share freely, never taking more than you give.

1.2. Table of Contents

1. Introduction
2. PRAGMA settings
3. Transactions
4. Indexes
5. Optimizing queries
6. Moving code into SQL
7. User functions
8. Callback functions
9. Reducing database file size
10. Reducing database load time
11. Reducing SQL query parse time
12. Hacking the source
13. Using the btree interface
14. Multiple threads
15. Operating system issues