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 <[email protected]> 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 > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
