[TV] Program list very slow (1 Viewer)

velis

MP Donator
  • Premium Supporter
  • July 16, 2009
    237
    50
    Radovljica
    Home Country
    Slovenia Slovenia
    MediaPortal Version: 1.1. beta
    MediaPortal Skin: Blue3 wide
    Windows Version: Win 7 Home Premium
    CPU Type: Athlon II 250 3GHz
    HDD: Seagate 120GB
    Memory: 2GB DDR3 1600
    Motherboard: Gigabyte Ga-MA790GPT-UD3H
    Video Card: Integrated Radeon HD 3300
    Video Card Driver: ATI Catalyst 9.11
    Sound Card: Onboard Realtek ALC889A
    Sound Card AC3: Optical SPDIF onboard
    Sound Card Driver: Win7 default
    1. TV Card: IPTV (no HW)
    1. TV Card Type: IPTV
    1. TV Card Driver: MP IPTV Filter
    2. TV Card:
    2. TV Card Type:
    2. TV Card Driver:
    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: TV: ATI Avivo, Movies: ffdshow
    MPEG2 Audio Codec: ffdshow
    h.264 Video Codec: TV: ATI Avivo, Movies: ffdshow
    Satelite/CableTV Provider:
    HTPC Case: Thermaltake DH-102
    Cooling: a bunch of fans
    Power Supply: LC Power LC-5500
    Remote:
    TV: Samsung LE37B650
    TV - HTPC Connection: HDMI

    Plain beta installation. No SVN builds, no plugins.
    When I press <ENTER> during live TV playback to see program list, it takes about 10 seconds to display approx 200 programs. And I don't even have EPG working yet. During this time, MP just freezes loading the program list from server database.

    Why does it take so long for 200 programs to load?
    Are there multiple SQL statements involved? If so, can a developer post them here so that I can take a look at them? I'm relatively good with SQL and it may be possible to optimize the statements into fewer (just one) that would execute much faster.

    Alternatively, is it possible to rewrite this piece of code so that it would display the list immediately and populate it from a separate thread?

    Logs not attached due to irrelevance.
     

    romuz

    Retired Team Member
  • Premium Supporter
  • July 26, 2008
    1,045
    250
    Moskau
    Home Country
    Russian Federation Russian Federation
    Wait for next SVN ,it consists program and epg showing speed improvements
     

    Users who are viewing this thread

    Top Bottom