-----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]
