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