Stress-testing SQLite

Richard Gaskin ambassador at
Fri Oct 29 20:17:40 EDT 2010

I have a need coming up for a data store that can robustly handle at 
least a million records, ideally up to five million, where each record 
may be as large as 5k.

I don't need relationality, so for me SQLite is an option but only an 
option; I'm happy to consider other options as well. (Yes, it has to be 
SQLite rather than MySQL, because it needs to work embedded with a 
commercial application).

Have any of you done stress testing on SQLite to that degree?

I've tried finding even anecdotal data on the web for SQLite limits, and 
while I can find citations of theoretical limits I haven't come across 
real-world usage stories of data sets that large.

Should I be confident in SQLite as a storage solution for that?  Should 
I be scared?

Thanks in advance for sharing your experiences with large data sets if 

  Richard Gaskin
  Fourth World
  LiveCode training and consulting:
  Webzine for LiveCode developers:
  LiveCode Journal blog:

More information about the Use-livecode mailing list