Re: Unable to store 500MB size of row data even after define macro SQLITE_MAX_LENGTH
On Thu, 7 Dec 2017 23:59:02 -0700 (MST), Durgesh
<[hidden email]> wrote:
> getting error "QSqlError("18", "Unable to bind parameters", "string or blob
> too big")" while inserting a row data of size 500MB.
> However insertion of 450 MB is successful.
> Tried define the macro SQLITE_MAX_LENGTH with value of
> SQLITE_MAX_LENGTH=2000000000 , larger than 500MB.
> pls suggest a way insertion can be done for more than 450 MB of data.
> I am using Qt SQL , for interfacing with sqlite db.
What is the databases page size?
How big is your page cache?
Is cache spill enabled?