[mythtv-users] Channel guide is way too slow

[Jelle De Loecker]

Op maandag 10-11-2008 om 12:57 uur [tijdzone +0100], schreef Friedrich
Clausen:
> Hi,
> 
> On Sun, Nov 9, 2008 at 3:06 PM, Rob Rosenfeld
> <rob+mythtv-users at rosenfeld.to> wrote:
> > On Sat, Nov 8, 2008 at 4:17 PM, Brad DerManouelian
> > <myth at dermanouelian.com> wrote:
> >> On Nov 8, 2008, at 1:14 PM, Jelle De Loecker wrote:
> >>
> >>> Hi everyone,
> >>>
> >>> So I have +/- 2500 channels in my channel list, the perks of using
> >>> satellite television.
> >>>
> >>> When I try to open the guide it takes about 50 seconds for it to load.
> >>> "Browsing" in this lists takes a while, too. When I press up or down
> >>> it
> >>> can sometimes take a few seconds.
> >>>
> >>> This is what happens on my dual core system, so you can imagine what
> >>> happens on my poor, little Apple TV! (running Mythbuntu)
> >>>
> >>> Once I've tried to "hide" most of the channels in the channels table.
> >>> (Nearly all, I only had 20 channels left) but that didn't do much
> >>> for my
> >>> Apple TV frontend: it was still browsing WAY too slow.
> >>>
> >>> I've read that disabling channel icons can help, but it really didn't.
> >>>
> >>> Mind you, I'm NOT even talking about the guide in live tv. I'm talking
> >>> about the regular kind, the one you can get to in the menu.
> >>>
> >>> I'm using the trunk of mythtv, btw.
> >>
> >> Missing icons can make for a VERY slow guide as it tries to find each
> >> one to display (and fails). Are you seeing channel icons?
> >
> > A database server with insufficient resources will also make guide very slow.
> 
> Another possible cause may also be your choice of de-interlace filters - See
> 
> http://www.mythtv.org/pipermail/mythtv-commits/2007-October/033074.html
> 
> As the reference above says, switching to something other than BOB
> deinterlacing may help. However, the long EPG startup time can best be
> solved with the DB "Optimize tables" script that comes with MythTV.
> And other DB tuning probably.
> 
> Cheers,
> 
> Fred.

The deinterlacer is only used for the LiveTV Guide, right? I'm not even
concerned about that right now if the regular guide won't even work fast
enough :)

Right now, I've disabled a bunch of channels:
only 123 of the 2827 are active, and that makes the loading indeed
faster.

>From 50s loading time to 5s, which is reasonable, I guess.
(The proprietary set-top boxes used by Telenet here take just as long
for not even half that number)

But regular browsing in the guide STILL isn't what it should be.
Going up and down, sometimes it just freezes for a second.

I have *disabled* the channel icons on my frontend and I have removed
the channel icons locations in the channels table.

However, even after disabling it, MythTV still wants to check for them:

2008-11-11 16:37:16.785 MSqlQuery::exec() "SELECT icon FROM channel
WHERE chanid = '13771' ;"

Why would it do that? Could this be the source for the
one-second-freeze? Maybe I should add a bug report for this?