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? Please advise. With regards, Sankara Narayanan B