erland;303524 Wrote: > The attached file contains the SqueezeCenter 7.0 table definitions, as > you can see there are already a lot of indexes setup for both the main > tables and the many-to-many tables. So I'm not sure if you just think > that no indexes exist or if you have really verified that there are > indexes missing that ought to be there. > > I haven't verified this 100%, but I think all the columns which are > included in a join directive should be indexed and probably also most > (if not all) of the columns which are part of where directives. > > If you enable the "database.sql" logging parameter in SqueezeCenter > settings, you should be able to see exactly how the SQL statements that > are executed looks like.
Thanks for this. I'll have a look at it in detail over the next couple of days. From the first look at it, I can see a lot of my suspicions confirmed but I want to check my facts and try to offer a contribution to a solution before I say any more. -- larrettp ------------------------------------------------------------------------ larrettp's Profile: http://forums.slimdevices.com/member.php?userid=10191 View this thread: http://forums.slimdevices.com/showthread.php?t=45261 _______________________________________________ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss