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. Thank you! ----- May -- View this message in context: http://sqlite.1065341.n5.nabble.com/Database-corrupted-28-billion-bytes-tp80048p80061.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
