mamema wrote:
>
> Number of song attributes;1095931
>
Ok as I suspected you have an extremely large LMS database. In
particular these numbers means that one of the Custom Scan tables have 1
095 931 rows and queries uses this table extensively in Custom Scan
based menus.
I suspect the issue is that Custom Scan data structures simply isnt
designed for this amount of data. Im guessing pretty much all menus
that uses Custom Tag or Mixed Tag scanning modules are slow ? Or does
some menus actually work fast and you are only seeing the issues in some
menus ? In that case which ones ?
Not sure if COMMENT and LYRICS can be long texts in your setup ? Do you
use these when browsing ?
Maybe someone reading this has some knowledge regarding how to optimize
performance in really large SQLite databases ?
Im afraid I cant help much more other than recommending that you
ensure to only scan attributes you actually need with Custom Scan. With
this amount of music files a scanned tag that isnt used is likely going
to have an impact on performance.
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
Developer of 'many plugins/applets'
(https://wiki.slimdevices.com/index.php/User_Erland.html)
*Starting with LMS 8.0 I no longer support my plugins/applets* ('see
here for more information'
(https://forums.slimdevices.com/showthread.php?49483-Announce-New-versions-of-erlands-plugins&p=998836&viewfull=1#post998836)
)
------------------------------------------------------------------------
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=101469
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
