Stress-testing SQLite

[Monte Goulding]

32TB db limit according to this:

http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems#Limits

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

Cheers

Monte

Sent from my iPad

On 30/10/2010, at 11:17 AM, Richard Gaskin <ambassador at fourthworld.com> 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: http://www.fourthworld.com
> Webzine for LiveCode developers: http://www.LiveCodeJournal.com
> LiveCode Journal blog: http://LiveCodejournal.com/blog.irv
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution