Re: [sqlite] Sqlite delete too slow in 4 GB database

On 4 Jun 2018, at 6:59am, ayagmur wrote: > When I try to delete 100 MB data by cascade (1 parent record - 100 child > records) it takes too long time (almost 10 minute) to complete, and the > duration increase/decrease by size of data (100 Mb: 10 minute, 300 MB: 30 > minute,etc) What medium

Re: [sqlite] Sqlite delete too slow in 4 GB database

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 wrote: > > > Hello, > > > > > Sqlite delete too s

Re: [sqlite] Sqlite delete too slow in 4 GB database

gt; 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 &g

Re: [sqlite] Sqlite delete too slow in 4 GB database

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 l

Re: [sqlite] Sqlite delete too slow in 4 GB database

On Sun, 3 Jun 2018 22:59:05 -0700 (MST) ayagmur escribió: > I have been using ext2 file system. I have a database which has 4 GB size. > Database consist of 1 parent table and 1 child table. Parent table has 10 > rows and child table has 4000 rows. 1 row of child table has 1 MB size. when > I

[sqlite] Sqlite delete too slow in 4 GB database

I have been using ext2 file system. I have a database which has 4 GB size. Database consist of 1 parent table and 1 child table. Parent table has 10 rows and child table has 4000 rows. 1 row of child table has 1 MB size. when I delete a row in parent table, deletion cascades 1MB-sized child