MrSinatra;649022 Wrote: > meaning what? you edited the config files manually?
The MySQL config files, yes. The server runs its own install of MySQL. > what are the differences between the SBS "high" setting and your edits? Larger buffers mostly. A lot more memory given to the process. > is the contention then, that properly configured, mysql will be better > and faster than SQLite? No, I wouldn't come to any conclusions, yet. As Andy says, there's still more to be done to optimize the performance. 7.6.1 with SQLite, prior to the WAL changes and the disabling of exclusive mode was definitely faster than MySQL with my library. From some other tests, though, it too appears to slow down significantly as the size of the database grows very large, whereas MySQL performance appears to be more linear. Where the crossover point is, in number of tracks, may be system dependent. -- JJZolx ------------------------------------------------------------------------ JJZolx's Profile: http://forums.slimdevices.com/member.php?userid=10 View this thread: http://forums.slimdevices.com/showthread.php?t=89513 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
