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)