there seems to be a significant performance bottleneck with persons and artists views in the dashboard, and its not related to cpu or disk subsystem performance.
perhaps the database is the constraint along with the query.
(roku and android clients dont seem affected but then their views have more spurious entries)
all my content is stored locally on 5400rpm hdds
my.application /ibn is stored on SSD (across 2 partitions of same ssd)
all my views are 500 large (500 for movies, albums, persons and artists)
if i click (in dashboard) (views configured 500 large)
home - movies - movies....the 1st 500 movies are shown <1second
home - movies - persons....it take 20seconds to show persons..
artist or album artists >20 seconds.
It is 100% reproducible for me and make no difference how many times the query is run (ie same after all images are cached etc
the cpu and hdds are not breaking a sweat when viewed in perfmon.
Edited by ginjaninja, 06 July 2014 - 07:27 AM.