Just to make sure, you both have the "Startup refresh" and "Rescan
refresh" options in Various Settings enabled ?
Is it possible for you to install the Database Query plugin and run its
"Custom Scan Statistics" report and post the result ? If you have
already posted it earlier, just link to that post.
I'd like to see the number entries for each tag in your library to make
it easier for me to simulate something similar in my own setup.
Does the issues only appear after you have used the system for a while
or do they also happen immediately after a rescan has finished ?
Do you have automatic rescans enabled in SBS
Settings/Advanced/Performance ? If so, could you try to disable it for
a while to see if that solves the issues ?
As a bit of background information:
- Custom Scan runs an analyze at SBS startup if the "Startup refresh"
option has been enabled, the purpose of this is to optimize the
database access based on the latest data.
- The same analyze operation is also executed at end of a rescan
I've seen issues where changing data without running this analyze
operation can result in slow queries laater, however, as long as you
have the "Startup refresh" option enabled, restarting SBS should solve
that.
These kind of issues never happened in 7.5 with the MySQL database, so
I'm pretty sure it's somehow related to the database backend. They
could probably be solved by manually switching 7.6 back to use MySQL
but that requires some manual configuration and it's not officially
supported by Logitech so there might be bugs.
--
erland
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 my answer
helped you and you like to encourage future presence on this forum
and/or third party plugin/applet development, 'donations are always
appreciated' (http://erland.isaksson.info/donate))
Interested in music discovery ? See 'Social Music Discovery (SMD)'
(http://forums.slimdevices.com/showthread.php?p=656713) project.
------------------------------------------------------------------------
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=90840
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
