On 01/21/2012 02:00 PM, Alexandr Němec wrote:
Dear all, we have another question regarding the 3.7.10 version. We have a database with cca 10 tables. After creating a new database in 3.7.10 and filling each table with about 10 - 100 data rows, we noticed that the size of the database is 2x - 4x larger compared to 3.7.9 (using exact same table structure and data rows). We think that it has to do with the schema format number, which is set to 4 by default in 3.7.10. So the general question is, does it mean that the new format needs more disk space for the same amount of data?
If you compile with SQLITE_POWERSAFE_OVERWRITE=0, then 3.7.10 uses 4096 byte pages by default. 3.7.9 used 1024 byte pages. So for small databases, 3.7.10 might produce bigger dbs by default. But the difference should get lost in the noise once you populate the db. You can get the old behavior by issuing a statement like: PRAGMA page_size = 1024; When creating the database. Dan. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
