I would like to create a SQLite file that contains 500,000 tonne value (between 0 - 256) according to my calculation, this file Should use approximately 5 [MB].
However, I'm getting close to the size file 50 [MB].
Here's the code that I use:
import sqlite3 # debug database = sqlite3.connect ('/ home / Mine / temp.db ') db.execute and populate (0, 5000000): (Enter the value in "(test)" ({0}) .db format (0)). ("Make the table if Test (id INT2) does not exist "). Committee () db.close () Any ideas how to optimize things so that it takes very little space?
5 There is too much of a database in comparison to the place for small boats. SQLite has published. It seems that you will need at least 9 bytes per line.
SQLite B -Tree uses two different versions of the structure:
- The table uses B-Tree, which uses 64-bit integer values for keys in table B-tree, an associated The database record (section 2.3.2) is deposited with each entry. Ika B-tree structures have been described in detail in section 2.3.4.
- Index B-tree, which uses database records as the key, index B-tree structures are described in detail in Section 2.3.3.
Comments
Post a Comment