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