sqlite3 - SQLITE -- a file with 5,000,000 TINYINT values? -


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