On Thu, 7 Dec 2017 23:59:02 -0700 (MST), Durgesh
<durgeshnmah...@gmail.com> 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?
See:
PRAGMA schema.cache_size;
https://sqlite.org/pragma.html#pragma_cache_size
PRAGMA cache_spill;
https://sqlite.org/pragma.html#pragma_cache_spill
PRAGMA schema.page_size;
https://sqlite.org/pragma.html#pragma_page_size
PRAGMA schema.cache_size;
Other things to look at:
PRAGMA schema.journal_size_limit;
https://sqlite.org/pragma.html#pragma_journal_size_limit
PRAGMA soft_heap_limit;
https://sqlite.org/pragma.html#pragma_soft_heap_limit
HTH
--
Regards,
Kees Nuyt
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
