Cleared space is not automatically reclaimed.
You can run "vacuum" which wiill reclaim the space.
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Advanced GEOINT Solutions Operating Unit
Northrop Grumman Information Systems
________________________________
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of vallur raghava reddy [vallur.raghavare...@gmail.com]
Sent: Wednesday, June 06, 2012 6:42 AM
To: sqlite-users@sqlite.org
Subject: EXT :[sqlite] Disk file size
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
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
