[EMAIL PROTECTED] wrote:
Hi,
I have started to use SQLite recently. I have an interesting situation of
deciding the database schematic for my solution. In one of the tables I
need to store contents of size 2000 * 20. If I could create 40000 rows
containing only one or two columns, my schema is quite convenient and
extendable at a later time. If I restrict that data to be of 2000 rows
with 20 columns, my solution is not extendable at a later time because in
future I may need to extend to 25 columns. I learn that to add a column, I
need to create some temp table and do copy operations (I got this details
from sqlite FAQ).
Here is my clarification.
If I have 40000 rows with two columns in each row, I find the db file size
to be around 1.2 MB. But if I store the same data in 2000 rows with 21
columns, I have the DB File size of around 300KB. Why is this huge
difference in file size. I am also quite new to Databases. If any one of
you could clarify whether I am doing something wrong or is it a feature of
Sqlite file structure?
Some hints:
* If you are using sqlite version 2.8, run sqlite_analyzer on the
database to get some useful information about how it uses space.
An equivalent tools for version 3.0 is in preparation.
* Read about the SQLite file format in the documentation on the
website.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
