Would it be a problem for those of you who are using the TrackStat plugin and run mysql if it only where able to store statistics for tracks with urls less than 256 characters long ?
The reason is that mysql indexing doesn't work today in MySQL 4.1 and later and by changing the datatype of the TrackStat table url column to maximum 255 characters the index seems to work which will greatly improve performance on some TrackStat operations. TrackStat would just ignore tracks with longer urls than 255 characters. So would it be a problem if I made this change ? You can check the number of "problem urls" in your library with this SQL: select count(*) from tracks where length(url)>255; -- erland Erland Isaksson 'My homepage' (http://erland.homeip.net) 'My download page' (http://erland.homeip.net/download) (Developer of 'TrackStat' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-trackstat) , 'SQLPlayList' (http://tinyurl.com/pptqy) and 'DynamicPlayList' (http://tinyurl.com/kfrgs) plugins) ------------------------------------------------------------------------ erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=23773 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/plugins
