This problem continues to itch me. Since my last post I have been talking with their tech support (sporadically) to no avail. They claim that they were unable to reproduce the problem with the copy of the database that I sent them, thus the problem is with something at my end. I somewhat accepted that for a time...until I did a clean install of the OS, and then tried the app before setting it to use my database. It was just as fast as it ever was, which would tend to point the finger at either the database or the app itself, but since they claim that they were able to run my database without any problems, they claim that the problem must be somewhere it my hardware.
The only thing supporting that idea is the occasional Out Of Memory error that sometimes pop up in certain operations, but I have never been able to get them to define precisely what memory that might pertain to, and may occur when physical RAM is not near it limits, virtual memory is set to use as much space as it wants, Windows Memory Diagnostic doesn't indicate any problem with the CPU's memory controller cache either enabled or disabled, and I've not found anything that indicates a problem with the video card's memory. Under the circumstances, I'm at a loss to understand the Out Of Memory error, or if it really is at the crux of the app's performance issue that I'm trying to deal with.
I also found that if I downloaded my movies from MC's Cloud, to a new, clean database, that no speed or performance issue appeared. This seemed to annul the idea that the number of movies cataloged was the problem, since the Cloud download was equal in size to my old database in terms of the number of movies. However some things were abbreviated, like the length of the cast and crew and a few other little items, but I find it difficult to believe that these are responsible for the problem either.
I can't use the Cloud to create a new database for normal use, because of the abbreviations that I mentioned...it would take forever to edit it to a working state, but they also have another online database service they call Connect, which isn't free like the Cloud. The problem is that I don't want to pay for something, unless I am fairly sure that it will help. Since it isn't free, I figure that it must be more complete, and would provide the data that I uploaded to it, rather than substitute some things from their own core system, but I've not found anything on their website that gives a clear picture, and they haven't responded to my questions about it, other than to state that they seriously doubted that it would solve the problem. I really dislike assertions such as that, without any real explanationsa to back it up, especially since all that I've found so far indicates just the opposite.
I know that many would simply toss this app aside and try to find another to do the job, but I've not found any that come close to doing what this one does...when it works properly. That's a lot of words to say that I'm still looking for the solution, and any help that might lead me to it.