HowTo Improve Movie & Music database speed 1,000 times | Page 2

Discussion in 'Tips and Tricks' started by HappyTalk, August 11, 2006.

  1. HappyTalk

    HappyTalk Portal Pro

    Joined:
    July 16, 2006
    Messages:
    307
    Likes Received:
    8
    Occupation:
    Coder
    Location:
    UK
    Ratings:
    +8 / 0
    Re actorinfo_idActor, actorinfomovies_idActor



    Hmmm yer I forgot I filled these 2 tables with dummy data during the intial migration of my myth db so the later looked unique - doh!
    That said I agree actorinfomoves_idActor is clearly not UNIQUE, but actorinfo_idActor does look like it should be UNIQUE to me? and looks like it could just be merged into the actor table. I've now removed both those indexes from the Original Post as I cannot see them being used much, cheers for the pointer.
     
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. sky_diver_

    sky_diver_ New Member

    Joined:
    January 2, 2008
    Messages:
    1
    Likes Received:
    0
    Ratings:
    +0 / 0
    You just saved me a couple of hours of hair pulling! And I only have a few hundred entries in movide DB! Before adding indexes configurator just slams CPU to the top, now it's vay much faster. Thanks!
     
Loading...

Users Viewing Thread (Users: 0, Guests: 0)

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice
  • About The Project

    The vision of the MediaPortal project is to create a free open source media centre application, which supports all advanced media centre functions, and is accessible to all Windows users.

    In reaching this goal we are working every day to make sure our software is one of the best.

             

  • Support MediaPortal!

    The team works very hard to make sure the community is running the best HTPC-software. We give away MediaPortal for free but hosting and software is not for us.

    Care to support our work with a few bucks? We'd really appreciate it!