--j2AXaZ4YhVcLc+PQ Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable
We use mysql heavily in production with tables over 30GB. We are going to purchase a new db server soon and the decision to be made now is whether we should go with a 4 cpu 700-900MHz system or a 2 cpu 1.4GHz+ system. Most of the time there is only one connection to this large=20 database doing large queries including joins. What I am trying to find=20 out is when (and how well) extra CPUs could speed up SQL operations when=20 there is only one client/connection. In the opinion of those who know,=20 which system would best serve our needs? The four slower processors, or the= =20 two faster processors? Why? Thanks in advance, Chris PS Please cc me responses as I only read this list through the archives. --j2AXaZ4YhVcLc+PQ Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.4 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE8SIkgRHOBDNKYhKERAvsvAJ942f100KcPzWFHcV6NQc4zNN9cyQCgiuPV CoBeRPrJ6Jt2hKNY8UoYxxc= =Pg9R -----END PGP SIGNATURE----- --j2AXaZ4YhVcLc+PQ--
