Moonbase;397437 Wrote: > Maybe youre right In the latter part of the process I see Perl not > using that much CPU anymore but mysqld working like hell eats about > 35-45% CPU but somehow blocks the whole SC system. Refreshing the scan > status screen is »loading« the page until the scan is finished, > actually. > > I wonder if poor mySQL has to handle Cartesian products here, due to > the complexity of stuff? (Thus probably needing to handle hundreds of > thousands of rows.) > Could you try to run it with Custom Scan debug logging enabled and see if you can see which steps that are executed at the end when mysqld uses most CPU ?
Moonbase;397437 Wrote: > > Btw, looking forward to your comments regarding my changes. Dont shoot > me down in flames, its just a quick hack, could probably be programmed > much more optimized ;-) > I'll try to include them in the next version of Custom Scan, I'm probably going to change the configuration a bit so you configure the mapping as a separate configuration parameter. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) 'My download page' (http://erland.isaksson.info/download) (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=49483
_______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/plugins
