JJZolx;206460 Wrote: > As of MySQL 5.0.3 varchar columns can be up to 65,535 bytes in length. > > http://dev.mysql.com/doc/refman/5.0/en/char.html Thanks, that might actually be the solution.
I know there was a reason I didn't use longer varchar, but I'm not sure exactly what it was. It might have been that I wanted it to work for people using their own MySQL 4.1 installations, it could also have been something with indexing. I just tried using a varchar(512) and doesn't seem to cause the 100% CPU problem on linux, so it is looking good so far. I'll just have to verify it with a larger database and make sure it also works on Windows. -- erland Erland Isaksson 'My homepage' (http://erland.homeip.net) 'My download page' (http://erland.homeip.net/download) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library and RandomPlayList plugins' (http://wiki.erland.homeip.net/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=35815 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/plugins
