2006-02-18, 04:26 AM
I've been concerned about the ever growing DB size over time. After a few days of EPG updates my database rapidly grows above 60GB and shows no signs of stopping.
So I've worked up a solution to keep the database compressed. I've set up a scheduled task to reboot the system in the early morning hours, ~ 7AM or so, when no one is normally using the system (the drawback obviously is possible recordings scheduled but I'm working on that problem.)
When the system reboots, "GB-PVR Recording Service" is set to Manual rather than Automatic start (the database must be idle for the compress to work.)
As part of the Startup menu I have modified my GBPVR start batch to
- launch MSAccess from the command line with the /compress option
- start the GB-PVR Recording Service
- launch GBPVR in the second display in fullscreen mode.
It's a very simple batch process at bootup:
----------
cd\program files\microsoft office\office
msaccess.exe "c:\program files\devnz\gbpvr\gbpvr.mdb" /compact
cd\
net start "GB-PVR Recording Service"
cd\program files\devnz\gbpvr
start gbpvr.exe -noframe -pos:1280,0,640,480 -topmost
exit
----------
This process keeps my database in the 6-10GB range which seems to help significantly when using the web interface, searches, etc.
The ideal situation would be to be able to tell when the database is idle i.e. no recordings, no one watching TV, etc. At this point the recording service would be stopped to release the database and the compress would run and the recording service restarted. This is beyond the batch capability and the logical place for this would be either in the main code or a plugin if the database status is available somehow.
So I've worked up a solution to keep the database compressed. I've set up a scheduled task to reboot the system in the early morning hours, ~ 7AM or so, when no one is normally using the system (the drawback obviously is possible recordings scheduled but I'm working on that problem.)
When the system reboots, "GB-PVR Recording Service" is set to Manual rather than Automatic start (the database must be idle for the compress to work.)
As part of the Startup menu I have modified my GBPVR start batch to
- launch MSAccess from the command line with the /compress option
- start the GB-PVR Recording Service
- launch GBPVR in the second display in fullscreen mode.
It's a very simple batch process at bootup:
----------
cd\program files\microsoft office\office
msaccess.exe "c:\program files\devnz\gbpvr\gbpvr.mdb" /compact
cd\
net start "GB-PVR Recording Service"
cd\program files\devnz\gbpvr
start gbpvr.exe -noframe -pos:1280,0,640,480 -topmost
exit
----------
This process keeps my database in the 6-10GB range which seems to help significantly when using the web interface, searches, etc.
The ideal situation would be to be able to tell when the database is idle i.e. no recordings, no one watching TV, etc. At this point the recording service would be stopped to release the database and the compress would run and the recording service restarted. This is beyond the batch capability and the logical place for this would be either in the main code or a plugin if the database status is available somehow.
ASUS A7V880, Athlon XP 3000+, 1024MB, 250GB (Prog/DB), 40GB (Buffer/Temp), 670GB SATA (Video Library), PVR150MCE Video (2), NEC DVD+/- RW, Liteon DVD, nVidia FX5600 AGP, Onboard AC 97 Audio, Hauppauge Remote, Girder, USBUIRT,802.11G WLAN, nVidia Platinum Decoders