turls;552454 Wrote: > Are the tweaks in here still valid? Yes. These are tweaks to improve the performance of MySQL in the special case of having a database small enough to fit into memory (MySQL is normally used with databases that do -not- fit). Further, the default settings that SqueezeServer uses for MySQL are for a machine with very little memory. Starting with SqueezeServer 7.6, if all goes to plan, there will be a choice between SQLite and MySQL as database systems. These tweaks will continue to work - but only if you've chosen / installed MySQL. Parenthetically, SQLite used to be really slow, which is why SqueezeServer has been using MySQL. But SQLite performance has improved over the last few years. Still not the appropriate choice for a big-ish database, but even with 200K tracks, Squeeze doesn't get into that range. Personally, I use a low-spec (for low power consumption) music server so I'm looking forward to trying SQLite.
Another angle with 7.6 is that, given that the current MySQL settings are for a "minimal" server, and that there will then be SQLite for that minimal server, I'd expect something like these "tweaks" to become the norm (no longer a need to accommodate those minimal boxes as SQLite's there for that). Hoping that makes it clear... PS: Just to put the "Squeezeserver's database is small" into perspective, a few years ago I setup a MySQL database that had hundreds of millions of rows. SqueezeServer's db is more in the tens or hundreds of thousands of rows (depending on the number of tracks) -- bobkoure ------------------------------------------------------------------------ bobkoure's Profile: http://forums.slimdevices.com/member.php?userid=14646 View this thread: http://forums.slimdevices.com/showthread.php?t=70371 _______________________________________________ discuss mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/discuss
