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
suddenly slow?
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
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
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.
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.
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.
Hi
Is it possible to open the videos by the program?
If not, why using it?
If not, why using it?
purpose is cataloguing, not being a media center