Erland, I think "Home > CustomBrowse > Tags" needs some optimization
still up to two minutes (!) here at 100% CPU until the tags menu
appears, 543718 rows examined. (Library has 26,208 songs.)
>From the mySQL "slow queries" log:
Code:
--------------------
# Time: 090320 21:38:30
# u...@host: [slimserver] @ localhost [127.0.0.1]
# Query_time: 68 Lock_time: 0 Rows_sent: 18 Rows_examined: 543718
select
customscan_track_attributes.attr,customscan_track_attributes.attr,substr(customscan_track_attributes.attr,1,1),customscan_track_attributes.valuetype
from customscan_track_attributes use index (attr_module_idx) where
customscan_track_attributes.module='mixedtag' group by
customscan_track_attributes.attr order by customscan_track_attributes.attr;
--------------------
--
Moonbase
Moonbase: 'The Problem Solver' (http://www.kaufen-ist-toll.de/moonbase)
------------------------------------------------------------------------
Moonbase's Profile: http://forums.slimdevices.com/member.php?userid=21594
View this thread: http://forums.slimdevices.com/showthread.php?t=49483
_______________________________________________
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
