On 1/16/15, MayW <supp...@dotysoftware.com> wrote: > Found table that was huge, it was named MyTable. > It was created with: > Create Table MyTable(comment); > > select max(rowid),* from MyTable; > 800020000 "This","is"," 40000" > > Drop table Mytable; > Vacuum. > It went down to a little over 3,000,000 bytes. > > I'm going to include a filesize routine within my programs to > test the .DB3 to see if it grows by some great amount in a day. > > What caused it to become huge, maybe a run-away test program? > > I made a backup so will run sqlite3_analyzer.exe, again. > Not sure what I'll be looking for. >
What sqlite3_analyzer would have told you is what you have already figured out - that MyTable was taking up most of the space. If you run sqlite3_analyzer on the new 3MB database, it will show you how much space is taken up by each of the remaining tables and indexes. That information might be interesting to you. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
