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

Reply via email to