Hi, I use a page size of 64 KB. But my row consists of 2 columns that is : i - Auto Increment Integer, b - 4096 Bytes of BLOB data
Now for the sake of calculation, lets say 16 rows fit in a page and my table has 10000 rows when I start. Now, lets say I delete some data which is not in sequence i.e. it can be deleted as per data which is not in use. To create such a hypothetical situation for explaining this to you, here is a simple query : DELETE from TABLE where i%4 = 0; As you may see that there is now 25% data deleted in each page. Now even if I do insert another 2500 rows (25% of original size) my database size reaches 125% of the original size when I inserted the 10000 rows initially. Hence there is significant space wastage. Anyway i can improve that ? It would be nice if the database size would be close to the original size after deleting 25% and adding some new 25% data. I know you would recommend to use smaller page sizes. Ideally 2KP page size is good but then, the number of pages is restricted to a max of 2^32 which will restrict the total database size to 4TB only. I need the max size to be capable of atleast 32TB. On Fri, Feb 7, 2014 at 11:14 PM, Donald Griggs <dfgri...@gmail.com> wrote: > Can you write more about how this is causing you a problem? Most users > don't experience this as a problem > On Feb 7, 2014 10:30 AM, "Raheel Gupta" <raheel...@gmail.com> wrote: > > > > > > > SQLite's tables are B-trees, sorted by the rowid. Your new data will > > > probably get an autoincremented rowid, which will be appended at the > end > > > of the table. > > > > > > A page gets reorganized only when about 2/3 is free space. > > > > > > > Anyway to make this ratio to lets say 1/3 ? > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users