Moving Pictures 1.3.1 Database Size

Discussion in 'Moving Pictures' started by ozwombat, February 15, 2012.

  1. ozwombat

    ozwombat Portal Member

    Joined:
    February 19, 2008
    Messages:
    15
    Likes Received:
    0
    Ratings:
    +0 / 0
    Home Country:
    Australia Australia
    Just wondering if its normal to have a database sitting around the 100mb mark.

    EDIT
    Just to add there are around 1100 movies in the database


     
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. guytpetj
    • Premium Supporter

    guytpetj MP Donator

    Joined:
    March 24, 2005
    Messages:
    424
    Likes Received:
    53
    Gender:
    Male
    Occupation:
    Director - Oil and Gas Exploration
    Location:
    USA
    Ratings:
    +58 / 0
    Home Country:
    United States of America United States of America
    Show System Specs
    Sounds a bit extreem. I have 5.7MB with 527 movies.
     
  4. ozwombat

    ozwombat Portal Member

    Joined:
    February 19, 2008
    Messages:
    15
    Likes Received:
    0
    Ratings:
    +0 / 0
    Home Country:
    Australia Australia
    Just to add a bit more to the story. The database file 131MB.
    Using SqlLiteBrowser the table "filters__movie_info__black_list" has 3,151,164 records with the "filters__movie_info__white_list" has 10k records
    If I delete these records there is no change in file size until i compress the database which brings it back down to 10MB, a more reasonable size.
     
  5. Dodgy Bob
    • Premium Supporter

    Dodgy Bob MP Donator

    Joined:
    July 10, 2008
    Messages:
    117
    Likes Received:
    3
    Gender:
    Male
    Ratings:
    +3 / 0
    Home Country:
    Wales Wales
    Show System Specs
    Hi Ozwombat,

    I logged into the forums to post a new thread about my DB size and speed of MovingPictures when I saw this, so thought I would post here instead.

    I've had my MP installation for over 2 years now (I think, getting old, hard to remember....er....) and in that time I've updated MP and MovingPictures numerous times. My DB size was 202MB and I have 1,600 films. Whenever I went into MovingPictures within MP for the first time it would take ages to update filters and categories. Whenever I started the plugin configuration it would take 3-4 minutes before the film list appeared. I started to get fed-up of the performance.

    I have another, client, MP set-up on my games PC and the MovingPictures DB on that was 8.5MB pointing to the same shares. That's a big difference.

    So, I blew away my MovingPictures DB and rescanned everything. My DB size is now 7.5MB, a difference of 194.5MB, or 4% of it's original size!

    The performance is great now. Within MP it goes straight into MovingPictures and the plugin starts immediately.

    I don't know what caused the DB bloat. Just the age? The multiple MP upgrades? The multiple MovingPictures upgrades? Who knows? But I think it's worth while keeping an eye on the DB and refreshing it every few months. Thanks to trakt this isn't a big deal.
     
  6. guytpetj
    • Premium Supporter

    guytpetj MP Donator

    Joined:
    March 24, 2005
    Messages:
    424
    Likes Received:
    53
    Gender:
    Male
    Occupation:
    Director - Oil and Gas Exploration
    Location:
    USA
    Ratings:
    +58 / 0
    Home Country:
    United States of America United States of America
    Show System Specs
    You may consider this MPDbArchiver to make regular back-up copies of your databases.

    I have had it in the past that a database would blow-up on me, it always happened after a series of dirty shut downs when the power went out due to lightening storms.
     
  7. fforde

    fforde Community Plugin Dev

    Joined:
    June 7, 2007
    Messages:
    2,666
    Likes Received:
    1,690
    Occupation:
    Software Engineer
    Location:
    Texas
    Ratings:
    +1,696 / 0
    Home Country:
    United States of America United States of America
    A 100mb database is definitely not normal, I will look into this this weekend. Are you guys using any external plugins that hook into Moving Pictures though? Trakt? IMDb+? StreamedMP?
     
  8. RoChess
    • Premium Supporter

    RoChess Extension Developer

    Joined:
    March 10, 2006
    Messages:
    4,205
    Likes Received:
    1,320
    Ratings:
    +1,712 / 2
    Using IMDb+ plugin, my current db3 file is around 35MB with well over 3000 movies, and have gone through many updates from previous version upgrades. The main size increase I got on mine last time was when I was messing around with Dynamic Actors and ended up with like 80,000 rows in some tables. Also the blacklist and whitelist tables were huge. I also had some other issues back then so I did a clean database, which was right before the update to MediaPortal v1.0, and I have stayed away from Dynamic Actors/Directors/Writers since then.
     
  9. Dodgy Bob
    • Premium Supporter

    Dodgy Bob MP Donator

    Joined:
    July 10, 2008
    Messages:
    117
    Likes Received:
    3
    Gender:
    Male
    Ratings:
    +3 / 0
    Home Country:
    Wales Wales
    Show System Specs
    I'm using trakt, follw.it, IMDB+ and StreamedMP!

    I did create a custom category of actors but removed it last month. I'm willing to accept that this was the cause.

    Having said that, my DB was 150MB after removing that category, the next time I checked it was 202MB. The only actions taken inbetween (if memory serves) was adding a couple of films and upgrading to the latest StreamedMP (with the latest plugin additions) and MovingPictures. It was then I decided to recan everything.

    Edit : I've got the backups (which I presume are taken when MovingPictures is upgraded).

    25/02/2010 - 1MB
    25/06/2010 - 7MB
    18/12/2010 - 14MB
    25/03/2011 - 17MB
    20/12/2011 - 65MB
    09/02/2012 - 200MB

    It was sometime between 20/12 and 09/02 that I noticed it was 150MB. I'm sure the category was removed before 20/12.
     
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!