On Wed, Jun 6, 2012 at 7:42 AM, vallur raghava reddy <vallur.raghavare...@gmail.com> wrote: > 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
Issue the VACUUM statement to compact the database. http://sqlite.org/lang_vacuum.html John _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
