antp.be forum

I've been using AntMovieCatalog for sometime and very happy with it.
I have just happened to up buy a new computer and reinstalled the software on the new system.
For some reason the program is slow. Not all of it, just specifically after an import from Internet (e.g. IMDB script) it used to take less then a second to refresh the fields with the imported data, not it's easily 10 seconds.

No, it's not an Internet issue, but I can't figure out what else can it be.
It's a large database but never noticed this until I installed onto the new system, so I think the database size (12M with external links to images) shouldn't be a problem really.

Any help on how to troubleshoot this?

Thanks

Do you also have the problem if you try to import a few movies in a blank new database?
Maybe the problem is due to a weird/long value in one of the fields of one of the existing movies.

I have created a blank database and imported about 100 movies. It goes very fast...

Given it's actually a database problem, how do I go repairing it?

Many thanks for the help!

It must be an entry in one of the existing movies that do that.
Possibly something in the drop-down lists; do one of the drop down lists have a weird/long value? Or is one of the lists particularly long?

Or else to try to find which movie cause it (assuming it is a particular movie and not the total amount), you could try to make a copy of your database, and on that copy each time delete half of the remaining movie: if it is still slow, continue removing half, if the slowness problem disappear delete the other half (meaning the movie in question was in the first deleted half), and repeat until finding a more limited number of movies... but the problem may disappear when there will be less movies

I have too many record to check them out manually, also sometime operations are painfully slow.

Is there a way to sort by "record size"? I suspect the problem to be caused by the biggest or the smallest one

Very last resort I have a backup from last may but I brought up the topic as somebody else my run into the very same problem at some point

Hence why I suggest to split each time in two the list, that's a quick method to find where the problem is, in a few steps you can isolate the problem.

Alternatively, you can export to CSV and open in Excel: if you set the columns on auto-width you'll be able to find the large values (though that description & comments will be big anyway).

How big is your catalog once zipped, without the pics? I can maybe take a quick look to it.

Ok, I didn'd brake the database in parts but have followed the CSV export idea.
It was immediately clear is that there were 2 record extremely long. and specifically with very long comments imported via IMDB.

Try yourself:
http://imdb.com/title/tt0188653
http://imdb.com/title/tt3021360

It appears like shortening manually the amount of characters into the comments field did improve the speed.

I have many records and would need to prune manually.

Can you test on your side and if you run into the same problem we have some consistency here.

Comments do not seem very long when importing 10 top user comments... but it may depend on what else you import in comment fields.

Is it possible to open the videos by the program?
If not, why using it?

purpose is cataloguing, not being a media center
But if the path to the file is stored in the URL field (or the recently added field "File path") you can open it via double click or via the menu on the right.