SQlite size questions

[davisj36]

Anyone know what I can use to either compress/remove or view some of the data from my gbpvr.db3. It's over 9GB! and I'm guessing that 9gigs is not a normal size for this database.

[sub]

9gigs doesnt sound very normal, and I've not seen any other reports of extreme sized gbpvr.db3 files. Its funny though - one of the reasons we moved away from the old MS Access MDB database to get away from the fact it always grew and never shrunk, leading to extreme file sizes. I think something has gone wrong in this case though.

I've got about 40 channels, with 7 days of lists, and my gbpvr.db3 file weighs in at 2.7MB.

You could downloading SQLiteSpy from http://www.yunqa.de/delphi/sqlitespy/ and try using the 'Vacuum database' menu option.

[davisj36]

Thanks... I'll try it tonight and let you know.

[User]

27 meg here with 11 days of data and 200+ channels.

[davisj36]

9.7 gigs down to 4megs. LOL... figure that one out! Everything is good now.

[sgilani]

resurrecting an old thread... GBPVR started getting reallllly slow, so I checked on the database size... 15.9 GB !!

So I'm doing the vacuum database thing as sub suggested, it's been going on for over 30 minutes now, grinding away.. I hope it works out in the end!

[sub]

I dont know what would cause these incredibly large databases, but I dont think its a common occurrance though. The SQLite databases have generally performed well, with very few problems reported.

I think this thread has the only two reports I've seen of huge database files with SQLite in the last year since the switch was made to SQLite.

[zehd]

Three reports...

I had what would normally be a 18Mb file explode to 5Gb....

According to the sqlite3 docs, sqlite likes to leave gaps where records were deleted from.

This makes the database file larger than it needs to be, but can speed up inserts.

http://www.sqlite.org/lang_vacuum.html

I thought it was from me removing whole channels lineups and re-loading them, over and over when I was testing ZSchedFix.... Probably was.

Added the vacuum command and kept the size down...

[sub]

I just checked my lounge PC that has been using SQLite since it was introduce about a year ago. I've got about 40 channels with 7 days of listings, which are deleted each night and reinserted, but its still only 3.5MB. I think our sun will go super nova before I ever reach 5GB

I've never done a vacuum command. I suspect it some bug in SQLite that can cause this to happen, rather than a normal thing that'll happen to everyone after enough EPG updates.

[zehd]

I just checked my lounge PC that has been using SQLite since it was introduce about a year ago. I've got about 40 channels with 7 days of listings, which are deleted each night and reinserted, but its still only 3.5MB. I think our sun will go super nova before I ever reach 5GB

I've never done a vacuum command. I suspect it some bug in SQLite that can cause this to happen, rather than a normal thing that'll happen to everyone after enough EPG updates.

Fair enough... I read that the vacuum command is safe enough. I'll just have it as an option for my db program...