Moving Pictures 1.3.1 Database Size (1 Viewer)

ozwombat

Portal Member
February 19, 2008
15
0
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
 

ozwombat

Portal Member
February 19, 2008
15
0
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.
 

Dodgy Bob

MP Donator
  • Premium Supporter
  • July 10, 2008
    117
    3
    Wales Wales
    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.
     

    guytpetj

    MP Donator
  • Premium Supporter
  • March 24, 2005
    424
    57
    56
    USA
    United States of America United States of America
    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.
     

    fforde

    Community Plugin Dev
    June 7, 2007
    2,666
    1,699
    39
    Texas
    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?
     

    RoChess

    Extension Developer
  • Premium Supporter
  • March 10, 2006
    4,345
    1,824
    Country flag
    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.
     

    Dodgy Bob

    MP Donator
  • Premium Supporter
  • July 10, 2008
    117
    3
    Wales Wales
    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.
     

    Users Who Are Viewing This Thread (Users: 0, Guests: 1)

    OP Similar threads Forum Replies Date
    M.Hulot Moving Pictures lässt sich nach Windows-Update nicht mehr öffnen Plugins & Erweiterungen 1
    cerberus Moving Pictures zeigt Film Spezifikationen nicht richtig Plugins & Erweiterungen 12
    P Configuration Moving Pictures Support d'installation et de configuration 0
    R [solved] Moving pictures importer wont add files from a removable drive. Is there a work around ? Moving Pictures 8
    badboyxx [solved] Moving Pictures and MediaPortal 1.23 Regeszter Edition Moving Pictures 93
    caveman [solved] Moving Picture 97% CPU Moving Pictures 9
    T Moving Pictures...seem to have 'lost' ability to display Movie info. (eg Resolution/Audio) Moving Pictures 2
    raffe [solved] Export tool and import support from MP-TVSeries & Moving Pictures to MP2 General 22
    M.Hulot Moving pictures startet nur im hintergrund und falscher version Allgemeines Supportforum 5
    T Neuinstalation - Moving Pictures probleme Installationsprobleme? 19
    S Problem wit .ISO files in Moving Pictures Moving Pictures 3
    olli14 Inhalt der Moving Pictures Datenbank in die Plex Datenbank kopieren MediaPortal Café 69
    T Moving Pictures Icon disappeared...and the program....??? Watch / Listen Media 1
    T Moving Pictures error after update to 1.19 Final...logs included! Watch / Listen Media 6
    J [solved] Moving Pictures vs. родной граббер, кинопоиск Помощь по MediaPortal 21
    R [solved] Files moved to new location - Easy way to update database? My TVSeries 7
    R Files moved to different location - Easy way to update database? Moving Pictures 2
    ge2301 [Finished] [MP2-782] Show mouse cursor only if it was moved more than 10 pixels MediaPortal 2 13
    O Want to move 21:9 video down to the screen bottom Watch / Listen Media 1
    horned_reaper [solved] Mixed artist pictures Fanart Handler 397
    F Picture on folder Feature Requests 9
    emphatic Pictures in the cloud - would a plugin be possible for services like Google Photos MediaPortal 1 Plugins 1
    A Video clips do not work in the Pictures folder General Support 10
    N [Finished] [MP2-789] MCE remote control Recorded TV and My Pictures buttons do not work MediaPortal 2 17
    Cowboy Playback Problem with CTD or sometimes BSOD watch/edit Videos 0
    Similar threads

























    Top Bottom