Stress-testing SQLite

Richard Gaskin ambassador at fourthworld.com
Fri Oct 29 19:17:40 CDT 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 
SQLite.

--
  Richard Gaskin
  Fourth World
  LiveCode training and consulting: http://www.fourthworld.com
  Webzine for LiveCode developers: http://www.LiveCodeJournal.com
  LiveCode Journal blog: http://LiveCodejournal.com/blog.irv



More information about the use-livecode mailing list