sqlperformancesqlite

Will I run into performance issues if I use a blob field as primary key in SQLite?

I have a sqlite database where all the primary keys are GUIDs. Currently they are stored as fixed length strings but I want to store them as blobs because it simplifies the code for storing and retrieving data. I converted part of the database and everything is functioning as expected. However, I'm not sure if I will run into performance issues.

For example, would a statement like this be faster on strings than blobs? 

SELECT * FROM table1 t1, table2 t2 WHERE t1.id = t2.parent_id

My intuitions says no, but that doesn't really mean anything.

Solution

  • The best way to find out is to run the queries against a profiler/SQLite's timer. Setup a test and run the query 1000 times with string, then 1000 times as a blob. Winner is the fastest.

    Intuition is one thing, hard data is another.