Apart from the fact that scanning and building palylists is considerably faster (20-25% in the case of scanning), I have run EXPLAINS on the SQL which shows far more efficient access paths to retrieve the same data. In the case of the 'contributor' Index, the query was taken to a completely different level!
I have posted these results/findings/recommendations on several forums (both Slimdevices and Netgear)and in a bug I have raised in the hope that somebody there will notice and try a few of these things out themselves. -- 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 [email protected] http://lists.slimdevices.com/lists/listinfo/discuss
