monte at sweattechnologies.com
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 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:
More information about the Use-livecode