Database size

Hello !

I'm currently starting with symbian databases. I'm not familiar with indexed databases, and don't understand very well all the concepts.

I have some problems to understand the behavior between index use or not. Let me explain :

I'm creating a table containing two char(128), two uint and a timestamp (I explained the different fields in order to show that one record is not so big ). During execution, i need sometimes to add a new record or only update the timestamp of an existing one.

When I create this table with an index, and add 6 records (and update those 6 ones at least one time), the size of the database is 23.5 KB

But, when I create it without index, and launch my app in the same conditions, its size is only 3 KB

How do I interpret this fact ? Maybe I'm stupid, but I really don't understand.

Another consequence of an index use is that when I tried to open my db, I check if it already exist. If not, I create it. With an Index on it, my app raise a system error if the table doesn't exist. Without index (and the same code ), this error is never raised ....

Thanks to everyone for any help !