ModelCitizen wrote: > I'm very interested in optimising MySQL for Windows use and would very > much appreciate it if anyone who does any testing with the settings > would report back here, stating their library size and the settings > they found worked best for them. My library consist of *only* 18,000 > (flac) songs but I've occasionally wondered if the performace of MySQL > on Windows might be improved and if the SlimDevices developers may have > overlooked that fact that the optimum MySQL settings for Windows and > **nix may vary, especially where large music libraries are concerned. >
Just so you know, 18.000 records is *nothing* for MySQL. If this is a problem with tuning somebody's done something very wrong indeed. I figure the cause of the slowness you complain about must lie somewhere else in the code. It's not Perl in itself either because I routinely use Perl scripts with MySQL that manage much larger datasets and it's all lightning fast (unless you make some silly mistake with indexes or something). This problem must be caused by something else in the programming. Regards, Peter _______________________________________________ discuss mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/discuss
