PasTim wrote:
>
> If I did look at creating indexes, how would I go about it? Doesn't a
> scan drop and recreate some of the tables? I've got a schema I
> produced somewhere and could have a crack at a few key joins.
>
If "<number of tags scanned> * <number of tracks in your library>" is
more than 40 000, it will drop tables and recreate the indexes using the
<Cache>/InstalledPlugins/Plugins/CustomScan/SQL/SQLite/dbindex.sql file,
so you should be able to just add the indexes to this file. After you
have added the indexes, you can either perform a rescan or you can just
restart LMS since the dbindex.sql file is also executed at server
startup. Just note that to remove indexes, you will have to perform a
rescan (if the above number if 40 000 or higher) or remove the data
using "Clear all" link in Custom Scan settings page followed by a rescan
of all scanning modules or remove them manually by running the "DROP
index someindexname" directly towards the SQLite database.
If you have "info" level logging enabled on plugin.customscan, you
should see a "Creating indexes" message in the server.log file when it
runs the "dbindex.sql" file.
It's also important to be aware that the cost of adding an index is that
writing to the database can take longer time, which in this case
probably would affect the scanning performance of Custom Scan module.
It should be possible to use the "Database Query" plugin and its "Free
form query" if you want to run SQL commands directly towards the
database.
Is there a particular level in the menu hierarchy that's slow ?
Like when it lists all Composers ? all Works ? or all work artists ?
Or are all menu levels slow ?
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets (both free and commercial)'
(http://wiki.slimdevices.com/index.php/User:Erland).
If you like to encourage future presence on this forum and/or third
party plugin/applet development, 'consider purchasing some plugins'
(http://license.isaksson.info))
You may also want to try my Android apps 'Squeeze Display'
(https://play.google.com/store/apps/details?id=info.isaksson.squeezedisplay)
and 'RSS Photo Show'
(https://play.google.com/store/apps/details?id=info.isaksson.rssphotoshow)
*Interested in the future of music streaming ? 'ickStream - A world of
music at your fingertips'
(http://forums.slimdevices.com/showthread.php?98467-Pre-Announcement-ickStream&p=743516)*.
------------------------------------------------------------------------
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
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
