TV Guide Fullscreen - possibly the most powerful TV Guide in the world. ;)
(2019-05-05, 01:38)JQZ* Wrote:
(2019-05-04, 07:56)primaeval Wrote:
(2019-05-04, 04:46)JQZ* Wrote: Hi primaeval. Would you have any idea why TVGF hasn't been removing old program data for me when it loads a new grab? For several weeks now I've noticed that source.db files keep getting larger and larger with each update. I checked the oldest programs in my guide before and after updating today. After the update I found the programs are still being shown all the way back to the 1st programs listed in the guide before the update.

Have you been manually modifying the tables in the database?
There are some cascade triggers in the default tables that cause old program data to be deleted.         

I actually took that into consideration when I tested it this time p. Three days ago I renamed the default 28,757 KB source.db with  notifications that, yes, I had deleted a few entries in (I was going to ask you about that), renamed xmltv.xml (though I wasn't sure if that was necessary), and ran TVGF to have it create a 'virgin' 19,402 KB db file containing no notifications or linked URLs. I renamed that to source.raw.db, then restored the names of the originals.

Yesterday I ran a new grab and let TVGF update. The 28,757 KB source.db jumped to 33,153 KB.

Then I renamed the default source.db, made a copy of source.raw.db, and renamed it source.db. Deleted (or renamed) the new xmltv.xml and ran TVGF again. That 19,402 KB db file with 'virgin' tables jumped to 23,745 KB.  Then when I ran TVGF and scrolled the EPG back to the earliest programs listed, they were the same as they were before the update.

EDIT: BTW, the size of the updated xmltv.xml grab had actually dropped from 24,938 KB to 22,422 KB. 

It was from that change I made to allow notifications from channels that aren't there any more.
I've changed it back in 0.17.445 so old programs should get deleted but it might need you to clear out notifications without current channels.
Reply


Messages In This Thread
moved by bry - by bry - 2017-01-23, 23:08
Alternate Skins? - by Kanipek - 2017-03-21, 18:06
Recording - by Kanipek - 2017-03-22, 18:20
RE: TV Guide Fullscreen - possibly the most powerful TV Guide in the world. ;) - by primaeval - 2019-05-05, 08:34
SetUp - by francismm - 2019-05-22, 15:32
RE: SetUp - by Cangeoboy - 2019-05-23, 20:36
RE: SetUp - by M89SE - 2019-08-09, 08:09
RE: SetUp - by JQZ* - 2019-05-24, 02:47
Logout Mark Read Team Forum Stats Members Help
TV Guide Fullscreen - possibly the most powerful TV Guide in the world. ;)8