Author
Topic: mysql performance (Read 646 times)

When I select Video or Audio in an orbiter it takes very long for the results to show (more then 10 seconds) and then scrolling through the results is also very slow. Is this normal behavior, am I missing some optimizations, should one manually create indexes or is there something else I can do to improve this?

And no it is not normal. Most of the time it happens when a) you have a slow hdd, or b) you have a very large media lib.

It used to be normal (2-3 years ago), but changes have been made to speed up the query (around 4-5 fold at least). These days the first display of the list should not take more than 3-5 seconds on a 15k entry media lib. The scrolling from one page to the next should not take more than a second or two (max).

I have however moved a lot of files manually and some on multiple locations. Could it be that LinuxMCE is still storing old locations and that way have duplicate entries? If so what would be the best way to get rid of the stale entries?