SQLite Forum

Performance Issue: How can I increase a performance?
Please do not do that. It will most probably cause lots of problems down the line, much worse than waiting 150ms for a record access.

Please review your data type declarations;
- there is no DATETIME type in SQLite, use a definition appropriate to your platform (you seem to be using a numeric type)
- use BLOB for fields holding UUIDs and store them as 16byte integers
- put heavily referenced fields (key fields, WHERE clause fields, and commonly selected fields in that order) toward the front of the record
- put variable sized text and blob fields towards the end of the record
- if item_id is a "record number" and you want to use it as a foreign key and don't particularly care about its numerical value, consider declaring it INTEGER PRIMARY KEY (read up about the magic involved)