RC3 Slow EPG (1 Viewer)

vvulture

MP Donator
  • Premium Supporter
  • June 3, 2006
    483
    8
    48
    Sydney
    Australia Australia
    Country flag
    Isn't MSSQL slower and more sluggish than MySQL ? If not, i don't mind switching over if it fixes the problem...

    There must another, simpler, way to fix this tho... :-(
     

    infinite.loop

    Retired Team Member
  • Premium Supporter
  • December 26, 2004
    16,163
    4,133
    127.0.0.1
    Austria Austria
    Country flag
    Isn't MSSQL slower and more sluggish than MySQL ? If not, i don't mind switching over if it fixes the problem...

    There must another, simpler, way to fix this tho... :-(
    Totally depends on whom you ask. ;)

    Fact is that MySQL and MS-SQL are both mature SQL-Servers.

    Problem is that geeks like mud-wrestling and thats why you see flamewars going on about "which is better".
    (Linux vs. Windows is another good example, but lets not go there. ;) )

    I choosen to stick with MS-SQL server which was the first SQL-Server that the MP TV-Server supported (many Server's in that sentence ;) )
    Until today, i did not regret it.

    Note:
    For testing i am using the MySQL Server as well, and during testing i was not able to spot any major issues either.

    So imo. you just choose the SQL-Server "you prefer".
    Like some prefer BMW over Mercedes and the other way around. :)
     

    ARH

    Portal Member
    October 27, 2006
    35
    0
    56
    I too have the very slow epg with mysql. About 50 schedules

    This stops me trying rc3 as most of my stuff is tv recording.
     

    KevinM

    MP Donator
  • Premium Supporter
  • April 27, 2007
    86
    3
    United Kingdom United Kingdom
    Isn't MSSQL slower and more sluggish than MySQL ? If not, i don't mind switching over if it fixes the problem...
    There must another, simpler, way to fix this tho... :-(
    For large applications with multiple concurrent connections MySQL would be much faster than the express version of MS SQL, but this is quite a small database so I doubt there is much difference at all.

    However, the implementation of MediaPortal on MS SQL Express appears to be much better than the MySQL one at the moment.

    I am fairly familiar with MySQL and I did try tweaking it to speed things up with MediaPortal. This was only partially effective - it still wasn't usable IMO. The MS SQL Express implementation does work well, but uses more memory and processes. From the tests I have done, everything went wrong shortly after the SVN19876 build which was OK. However, using MS SQL, scrolling speed is still quite a bit faster than SVN19876
     

    vvulture

    MP Donator
  • Premium Supporter
  • June 3, 2006
    483
    8
    48
    Sydney
    Australia Australia
    Country flag
    ok...

    I decided to install SQL Express.... Although the TV Guide response time has dropped from 4 secs down to 0.5 secs, it is still slower than my previous MySql setup..

    But now it is once again useable.... :)
     

    rtv

    Retired Team Member
  • Premium Supporter
  • April 7, 2005
    3,622
    301
    Osnabruck
    Germany Germany
    Okay for a start:

    If you just have an unreasonable amout of channels in your groups you could try adding these indices:

    Code:
    ALTER TABLE program ADD INDEX IdxProgramStartTime(startTime);
    ALTER TABLE program ADD INDEX IdxProgramIdChannel(idChannel);
    and tell me if it helps at least a little bit.

    If you want to help finding the reason please try the attached tvplugin.dll. It's based on latest SVN and should not be used for the girl friend's system as it might not display the TVGuide's "red dot" as recording indicator at all ;)
    However I am very interested if this is noticeably faster.
     

    Users who are viewing this thread

    Similar threads
    OP Title Forum Replies Date
    T Client / Server slow channel-to-channel change (zapping) General Support 1
    C Importer works super slow My TVSeries 6
    doskabouter 1.23.0 Slow rendering times Bugreports 46
    A Client/Server Setup: Slow TV Startup Television (MyTV frontend and TV-Server) 0
    F GUI incredibly slow Performance General 22
    P Very slow start My TVSeries 2
    D Problem getting Schedules Direct EPG to load data Installation, configuration support 0
    R 1.27.0 Digiguide for epg for DVBS Electronic Program Guide 0
    CyberSimian Split programmes in the UK DVB-T EPG TV-Server 0
    C MP2 - V2.3.1 EPG view: incorrect displayed fonts Submit: Bug Reports 2
    R Deadlock in TV Server if recording while importing EPG TV-Server 10
    C MP2 - V2.3 Nereus: EPG context menu not available anymore at a running program General 8
    P MP2 - V2.3 EPG Frustration................ General 20
    cbr954rr Clickfinder epg import wrong channels? General 0
    cbr954rr EPG Genre map categories do not match tv server categories General 4
    cbr954rr Rename epg-genre category General 5
    M Add Radio channels and EPG to Mediaportal xmlTV 3
    M EPG color by length of TV-show MediaPortal 1 Talk 1
    D Downloading EPG XML file: Installation, configuration support 0
    D EPG No Data General Support 2
    D [solved] EPG Data off by -20 hours? General 10
    G Q about scheduling weekly series when epg lists duplicate back to back episodes each week General Support 2
    F Mini EPG more information? WMC Skin 4
    N No TV or EPG on fresh install General 0
    framug No color in TVGuide when XMLTV without DVB EPG MediaPortal 1 Talk 59

    Similar threads

    Top Bottom