gharris999;514960 Wrote: > Erland: thanks for that. It's long overdue for me to kick the tires on > your plugins, so I'm not intimately familiar with how they work. I > assume that you allow the user to enter a certain amount of raw sql to > be executed by your plugin. Is that why you use the eval?...to catch > syntax errors? > I both have raw SQL entered by users and raw SQL hard coded by me.
gharris999;514960 Wrote: > > Also, are you making use of REGEXP in your queries? Or does that tend > to be too expensive, requiring the entire record set to be evaluated? > I don't think I've used REGEXP anywhere yet, I suspect it will work pretty fast. The situations where I've got performance problems is often when I've tried to join several tables, especially when I've been forced to join with the tracks.url column which is defined as "text". -- 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=75024 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
