2005-11-10, 09:37 AM
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
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
EPIA 800Mhz 256Mb 160gb PVR-150 + MVP (mvpmc!!) GB-PVR 95.16