Using SQLite with Qt: squeeze every CPU clock to get faster

Gianbattista Gualeni

SQLite with Qt is simple, but storing 1M images thumbnail can be challenging. Let me show how I create an image database that is fast, scalable and reliable even running from a NAS. How Batch Execution effect number of query per seconds? How can I Bind values for the query? Is Transaction faster?

Qt and SQLite * Basics of database creation * Pros and Cons of SQLite * Basics of Query using SQLite * Read / Write performance of the database * Using the database to store images? Why can be useful? * Optimisation * Running Batch * Query Bind * Using Transaction * PRAGMA?

track icon Ercole
duration icon 60 min
language icon English
level icon Beginner