Performance of SQLite databases
Compared to a computer, a smartphone provides a very constrained environment for an SQLite database. To achieve optimal performance on a BlackBerry device, consider the following constraints:
- The dynamic memory limit is 5 MB. This limit refers to the amount of RAM available to an SQLite database for storing internal data structures for schemas and transactions. The entire database schema is loaded into memory when an SQLite database is opened and persists until the database is closed.
- The maximum SQL query length is 8192 bytes.
- Only one read-write database connection to an SQLite database can be made at a time. Other database connections are read-only.
Previous topic: Code sample: Creating an encrypted SQLite database