On 15 Jul 2004, at 15:53, D. Richard Hipp wrote:
In SQLite version 3.0, there is no theoretical limit on the size of
BLOBs. (The limit is really about 4.6e+18 bytes, but file size limits
will come into play first so you will never get to that size.) However,
the same MAX_BYTES_PER_ROW constraint is still in place. So with a
default build, the maximum BLOB size is still about 1MB. You can,
I suppose, increase MAX_BYTES_PER_ROW to whatever value you want and
recompile. But, if you make MAX_BYTES_PER_ROW really big, I think
you will find that performance gets very bad for very large rows.
OK, but what is performance like for small rows if you increase MAX_BYTES_PER_ROW?
Matt.
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email ______________________________________________________________________
