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
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
