Hi,
I have created a database "MyDb.db" and created a table MyTable using
the query *create table MyTable (id INTEGER PRIMARY KEY, value
CHARACTER(10))* and inserted 3000 records in the table.I executed query *select
* from MyTable* it returned 3000 rows and was able to print all values.
Now the size of the db file MyDB.db is 57kb.
After that I have deleted all the records and then I executed query *select
* from MyTable* it returned zero rows.
Now I have checked file size and it is same as 57kb.
So my question is, why does the file size is not decreased after deleting
the rows?
Is it like the SQLite will reuse the disk space later or something?
Please let me know about this
Thanks
Raghava Reddy
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
