Cleaning the EPG data...

[steves]

I decided to try out cleaning the EPG data last night to maybe help with performance....

The size of the gbpvr.mdb file was around 98meg!
I hit the "Empty EPG" button, and it thunk for quite a while. But when I opened the db in access there were still 31000 rows in the programme table, with some repeated rows!
Repeated pressing of the empty epg button still didn't clear out the data. I tried with the recording service stopped & Access closed (in case of locking issues). No dice.

Eventually I decided to to the clean manually with Access (after making a backup of the DB). After cleaning & compression the DB was at about 512Kb.
After an "UpdateEPG" it went up to 65Meg!!!
(I load 2 weeks of data & the XML file is approx 8 meg long)

So two things here:
1) "Empty EPG" didn't really do an empty.
2) Why is the DB sooo big? Is this just access?

An extra complication was that some preexisting recordings changed name e.g. "Frasier" became "Judge Judy" etc Obviously due to the fact I'd deleted the original programme IDs & the recording IDs pointed to new programmes.
So what would I need to do to do a safe clean?

Cheers

Steve

[blader_se]

I hit the "Empty EPG" button,

In the config program? Try the command line gbpvr -OnlyEmptyEPG instead.

[steves]

Yes config program only. I'll try the cmd line!

Cheers!
Incidentaly I was thinking of doing this every time I did an actual EPG update (I download over modem twice a week). How would this affect my scheduled recordings?