Are you running Linux or Solaris on these servers? Andrew.
----- Original Message ----- From: "mac" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, July 02, 2004 4:42 PM Subject: INTEL vs. SPARC > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > hi there, > > hope this haven't been discussed in that kind of detail in older topics: > > the facts in short: > - - we have the same mysql-version (4.0.18) for an intel-machine and a > sparc-machine. > - - we have a table with about 5,500,000 rows > - - we do a "realtivly" simple select on a varchar-50-field (with an > index of course) > - - the statement takes 4s on the intel- and 24s on the sparc-machine > - - we played around with some caching-features on the sparc-side but > there was no significant increase of speed > > the hardware: > sparc: > Sun Fire V480 > 4 x UltraSPARC III Cu Processor 900 MHz > 16GM RAM > > intel: > Compaq DL380R02 > 2 x Pentium III 1.1 GHz > 4 GB RAM > > the installation on the sparc was done with a precompiled version. the > intel-one was compiled by our self (but no special configue-options). > > > we also ensured that the index on the sparc side is in good shape. > we also tested it with the same setup on an older enterprise 450 - same > bade timing. > > > if you need more detail i can deliver them. > but i am more interested in a general question: > > does the speed of mysql depends more on things like the processor than > other resources? > if so: what kind of general suggestions can be made about using > select-statements on huge tables to be "fast" over different platforms? > > i am also aware of the hints about not using to huge logtables for > statistical output rather then creating small statistic tables. > this is something we will do, but we also need sort of guidelines for > future projects. > > > thanks in advance for your suggestions. > > with regards > mac > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.2.3 (Darwin) > > iD8DBQFA5YJVvkHn/oGTPXURApvwAKDBBcLtRH+S1+tBLsrFNmimtSki+gCgkQA6 > MEQxsqwYzRjQx+lN+epJtao= > =2VNS > -----END PGP SIGNATURE----- > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]