Re: [sqlite] Sqlite delete slow in 4GB

On Wed, 6 Jun 2018 14:33:12 +0300 Aydin Ozgur Yagmur escribió: > I was applying the changes. After moving blob to last column suggested by > Hick and eduardo, 500 MB delete took 40-45 seconds. > I was already attempted to change page_size & cache size but i had not seen > any significant

Re: [sqlite] Sqlite delete slow in 4GB

I was applying the changes. After moving blob to last column suggested by Hick and eduardo, 500 MB delete took 40-45 seconds. I was already attempted to change page_size & cache size but i had not seen any significant improvement, so i didnt apply this now. could you please explain positive

Re: [sqlite] Sqlite delete slow in 4GB

On Wed, 6 Jun 2018 12:06:15 +0300 Aydin Ozgur Yagmur escribió: > Thank you very quick response. > > We have already planned to change file system. But this problem seem not > related with the file size, because we did not hit the limit and when i try > to delete same data in ,for example, 2

Re: [sqlite] Sqlite delete slow in 4GB

Thank you very quick response. We have already planned to change file system. But this problem seem not related with the file size, because we did not hit the limit and when i try to delete same data in ,for example, 2 GB-sized db, i encounter with the same problem. This is my table and index

Re: [sqlite] Sqlite delete slow in 4GB

On Wed, Jun 06, 2018 at 09:27:57AM +0300, Aydin Ozgur Yagmur wrote: > I have been using fat32 file system. I have a database which has 4 GB size. Er... I'm surprised there aren't more problems due to 4GB being the max file size supported by fat32. Any chance to change it to exFAT? K

[sqlite] Sqlite delete slow in 4GB

I have been using fat32 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. There are unique indexes on the tables. When I delete a row in parent