dsdreamer;557646 Wrote: > > Edit: I think this is down to trying to join two text columns in MySQL > which doesn't benefit from indexing. Erland said something about this a > while back which sounded convincing to me: > http://forums.slimdevices.com/showpost.php?p=512973&postcount=35 > Andy solved that particular problem by adding a urlmd5 column to the tracks table in a later 7.5 embedded version. However, joining two text columns can definitely cause issues like this.
Mnyb, are you using any third party plugins that could cause problems ? For example any of mine which executes SQL statements after the standard scanning process. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher and Database Query plugins' (http://wiki.erland.isaksson.info/index.php/Category:SlimServer)) ------------------------------------------------------------------------ erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=79251 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
