If you don't already do this, you'll want to be sure the large blob(s) are the *last* fields in the table definition.
On Mon, Jun 4, 2018 at 8:49 AM Paul Sanderson <sandersonforens...@gmail.com> wrote: > Have you made sure aut_ovacuum is disabled? > > pragma *auto_vacuum * = 0 > > have you got a nice large pagesize if your records are that big? > > > > Paul > www.sandersonforensics.com > SQLite Forensics Book <https://www.amazon.co.uk/dp/ASIN/1980293074> > > On 4 June 2018 at 13:01, Olivier Mascia <o...@integral.be> wrote: > > > Hello, > > > > > Sqlite delete too slow in 4 GB database > > > > What does: > > > > 'pragma secure_delete;' > > > > and > > > > 'pragma auto_vacuum;' > > > > say, on that db? > > > > -- > > Best Regards, Meilleures salutations, Met vriendelijke groeten, > > Olivier Mascia > > > > > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
