Stress-testing SQLite

Monte Goulding monte at
Fri Oct 29 22:12:17 EDT 2010

32TB db limit according to this:

Maybe use limit and offset to page through query results though.



Sent from my iPad

On 30/10/2010, at 11:17 AM, Richard Gaskin <ambassador at> wrote:

> 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:
> Webzine for LiveCode developers:
> LiveCode Journal blog:
> _______________________________________________
> use-revolution mailing list
> use-revolution at
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:

More information about the Use-livecode mailing list