RC3 Slow EPG (1 Viewer)

[KevinM]

TV-Server Version: RC3 (Build 20432)
MediaPortal Version: RC3 (Build 20432)
MediaPortal Skin: Monochrome / Blue3
Windows Version: XP MCE 2005 SP3
CPU Type: Intel Pentium 4 3GHz
HDD: 250GB Western Digital (WDC2500KS-22MJB0)
Memory: 1024MB DDR
Motherboard: Kingston PC3200
Video Card: Sapphire ATI Radeon HD 3450 Silence "Low Profile" 256MB DDR2 TV-Out/DVI/HDMI (PCI-Express) - Retail
Video Card Driver: ATI Catalyst 8.5
Sound Card: Realtek High Definition Audio
Sound Card AC3:
Sound Card Driver: 5.10.0.5028
1. TV Card: Pinnacle PCTV Dual DVB-T Pro PCI
1. TV Card Type: DVB-T
1. TV Card Driver: Pinnacle Systems 3.2.4.0
2. TV Card: Hauppauge WinTV-HVR1300
2. TV Card Type: Hybrid DVB-T, Analog
2. TV Card Driver: BDA 2.119.25023.0
3. TV Card:
3. TV Card Type:
3. TV Card Driver:
4. TV Card:
4. TV Card Type:
4. TV Card Driver:
MPEG2 Video Codec: Cyberlink Video/SP Decoder (PDVD7)
MPEG2 Audio Codec: MPA Decoder Filter
h.264 Video Codec: Cyberlink H.264/AVC Decoder (PDVD7.x)
Satelite/CableTV Provider:
HTPC Case: Elonex Artisan LX
Cooling:
Power Supply:
Remote: HP Media Center p/n 5187-4401 (MCE Equivalent)
TV: LG 42LF65
TV - HTPC Connection: DVI to HDMI

The EPG in RC3 is painfully slow - almost to the point of being unusable - anyone else had this issue? (BTW, I use MySQL instead of MS SQL Express)

(I've tried it with Blue3 and Blue2 Wide : same result)

 

[safcsat]

the whole rc3 fresh setup is slow i wuld say. not impressed.

going to try some new skins see if that helps.

 

[ronilse]

Hi,
Not slow here so attach all logs collected with "MP log collector" to your post & is this using single/multi seat?

Regards
Roy

 

[KevinM]

OK - I ran MP through the diagnostic tool and have attached the logs.

Basically, I just went into MYTV and accessed the guide.
I used the remote to move down to Film4, initially quick but when I got to the last line in the display, it took approx 4 secs to scroll down each new line.
Then I moved right and turned off a recording. Slightly quicker but still seemed to take about 2 secs per right scroll when going off the page.

Update: Forgot to say - this PC is the TV Server and is also the main client. However, I do have other clients on my network running older versions of MP Client. It obviously isn't a problem with the TV server because the EPG works fine on remote clients

 

[safcsat]

I have just switched to Aeon wide and perfect as ever

 

[infinite.loop]

i can not confirm slow EPG in multiseat nor in singleseat.

~50 channels with 14days EPG displayed when i enter TV guide using M$ SQL Express.

 

[KevinM]

I tried switching to my usual skin (Monochrome) but it doesn't make any difference.

Maybe the issue is only present when you use MySQL instead of MS SQl Express - can anyone else using MySQL confirm whether their EPG is working OK ?

I checked the CPU usage on the server during EPG scrolling using both the local client and a remote one running RC2.

Quite high peaks in RC3 ~ 28% usage. The 4 peaks to the right of the screenshot each represent a single line scroll.
Negligible load on the server when accessing the EPG from a remote client - and this was for rapid vertical scrolling several times through the full channel list.

 

[KevinM]

Additional information:

I have now updated a remote client from RC2 to RC3 and the extremely slow EPG is there as well.

I uninstalled RC3 from the remote client and reinstalled RC2 TV client. EPG scrolling speed is restored.

I should mention at this point that when I installed RC3 Client+Server on the main PC, I did a full uninstall of RC1, but I didn't uninstall MySQL - could this be a cause of the problem?

 

[KevinM]

This problem appears related to an issue experienced by RC2 SVN users.

Summary of my results so far:-

The remote client running raw RC2 MediaPortal/TV Client works fine
The remote client running RC2 SVN20268 MediaPortal and raw RC2 TV Client works fine

The remote client running RC2 with SVN20268 (MP + TV Client) is very slow
The remote client running RC3 MediaPortal/TV Client is very slow

The remote client running RC3 MediaPortal and RC2 SVN19778 TV Client works fine (!)
The remote client running RC3 MediaPortal and RC2 SVN19876 TV Client works fine (!)
The remote client running RC3 MediaPortal and RC2 SVN20143 TV Client is very slow

 

[rtv]

I should mention at this point that when I installed RC3 Client+Server on the main PC, I did a full uninstall of RC1, but I didn't uninstall MySQL - could this be a cause of the problem?

Yes. Our own, tweaked config file for MySQL has been introduced with RC2. The typical installation defaults of MySQL is e.g. using way too little sorting cache as it is optimized for "background" usage.

The queries itself are handtweaked to the peak - gathering program info takes around 5 ms here. The rest is ineffective GUI code.

Nevertheless MSSQL can use available RAM much more aggressive and responds to most queries directly from its cache. So while some actions (Mini-EPG, EPG import) might be faster with MySQL, M$ SQL Server will be faster for TVGuide of huge groups and everywhere where "gentle.NET" is used (e.g. channel assignment in SetupTV.exe).

P.S. On the same hardware SQL Server 2008's query response time is even 25% faster.