Stress-testing SQLite

[Monte Goulding]

On 31/10/2010, at 4:55 AM, Richard Gaskin <ambassador at fourthworld.com> wrote:

> Lynn Fredricks wrote:
> 
>>> 32TB db limit according to this:
>>> 
>>> http://en.wikipedia.org/wiki/Comparison_of_relational_database
>>> _management_systems#Limits
>> 
>> Charts like this, especially on Wikipedia should be taken with a grain of
>> salt. Feature comparisions (yes/no) I can appreciate, but when it comes to
>> capacity and performance, that's a bit different.
> 
> Indeed.  With LiveCode, for example, fields can *theoretically* hold up to 4GB, but I pity the person who tries it.

My point was that given your expected max db size of 5kB * 5000000 is 23GB this is only a very small fraction of the stated theoretical limits of SQLite. 

Cheers

Monte