[mythtv-users] Very slow navigation in guide

[Raphael]

Matt Doran wrote:
> Alex Halovanic wrote:
>   
>> Yes, it definitely can hit the 5-10 second mark in pauses, especially
>> when paging up and down through the guide, but sometimes even when
>> moving up and down or forwards and backwards one entry.  Its not all
>> the time either; sometimes the guide responds relatively snappily,
>> other times it pauses for seconds and then starts jumping about wildly
>> as it responds to all the remote presses I made attempting to get it
>> to move.
>>
>>
>>   
>>     
> Yes, that's what I see.  It's pretty annoying.
>
> Verbose logging didn't give me much information to understand what the  
> problem is.   All I see is a pause in the SQL statements.
>
> When I get some time, I'll add some more debugging and see if I can 
> understand what causes the pauses.
> _______________________________________________
>   

Chiming in with a "me too" here. I get pauses all the time trying to 
browse the guide. One thing that is particularly annoying is that I like 
to type in the channel number. Now when I type a channel number, there's 
a delay of 2 or more seconds before the input registers and it shows the 
number onscreen and switches in the guide. So, if you type "320" too 
fast, you might end up on channel 3, channel 20, channel 3220, or 
anything in between. I have to type 3, wait a second, type 2, wait a 
second, type 0 to finally get to 320...

It just started happening recently, and I feel that in my case it is 
somehow the result of getting 700 new channels. Previously I was using 
cable with only 75-100 or so channels and the guide was always super 
snappy, TV preview or not. Now, with this digital cable thing there are 
tons more channels, and I feel like mysql being too slow could be the 
problem, as if somehow the channels table is so big it's having issues 
just searching through it.  But really, I don't know a think about how 
the database works, and have no idea how to fix this.
Could it also be because I have two line-ups, so some channels (2-100) 
are duplicated (one on each input)?

Raphael