Suggestion to improve guide load time

[JEF]

Thanks for the tip.It work great loading the EPG in less than a second !

[HarryH3]

I'm also using SQLLiteSpy. It let me create a unique index with no errors. I just removed the unique index using "drop index programme_epg" as recommended by dennit. Thanks! Then I created the non-unique index using "create index programme_epg on PROGRAMME (channel_oid, start_time)" and it seems to have worked perfectly.

We mainly use GB-PVR via two MediaMVP's and the EPG used to take quite some time to load. With this change the EPG loads to the MVP too quickly for me to even see a blank time slot in the guide. Kudos to wtg for coming up with this idea!

[cb123]

scb147,

I know you just attempted this, but have you setup a season recording yet? I'm just curious because I have ~200-250 channels for 14 days. If I setup a season recording, GBPVR freezes at least 30 seconds, and up to a couple minutes.

Have you checked the logs for database locked errors after a freeze? Thirty seconds matches with the default timeout for the database. On my system every season recording freeze has been caused by database locked errors. Sometimes it would recover from being locked, schedule some more recordings and then become locked again .. freezing for multiples of 30 seconds.

[scb147]

scb147,
Have you checked the logs for database locked errors after a freeze? Thirty seconds matches with the default timeout for the database. On my system every season recording freeze has been caused by database locked errors. Sometimes it would recover from being locked, schedule some more recordings and then become locked again .. freezing for multiples of 30 seconds.

I haven't checked the logs for a db locked error. I will next time it happens. Thanks for the heads up.

[User]

I checked my epgextra log and it looks like the actual guide update for 14 days took only a couple of minutes and the run of epgextra went from 76 minutes to 82 minutes. Database size seems not to have changed by much. I also use gbpvr over MVP's and the performance increase is amazing loading the guide or doing a search with searchwiz.

Later edit-
Guide data loads in about 7 seconds where before it took several minutes.
Have not seen any error boxes when exiting pvrx2 on the pc. previously I got an error box maybe 20% of the time.

[tiger66]

FYI - This change worked great for me too. I first made the new index unique, then went back, removed it, and created a non-unique index. It really helps with the Guide load time. Thanks for the suggestion.

[dennit]

I've also had trouble stopping active recordings - and I suspect this was related to the timing issues of my large db. I have hopes that your index will help with this issue too..

It doesn't seem to have helped me with this issue - too bad, but it's still a great improvement on EPG load times.

[Graham]

Is the non_unique condition caused by an EPG update that adds a show with a different name to a timeslot that contains a pending recording?

I run an EPG update on Day 1 and grab 14 days of listings. I schedule a recording for a show at X time on Day 7.

Something momentous happens on Day 3 ... UK wins the Eurovision Song Contest.

I run an EPG update on Day 5 that loads a replacement show at X time on Day 7 ... a documentary on previous UK Song Contest victories.

Would the database now contain two entries for X time on Day 7?

I care deeply about who wins the Eurovision Song Contest ... Not.

[cad]

Great tip. All the programs instantly.