Richard Skelton wrote:
> I have downloaded the mysql-3.22.22-sun-solaris2.6-sparc.tar.gz for my machine
> and mysql-3.22.22-sun-solaris2.5.1-sparc.tar.gz for my target machine.
> It installed fine on both machine and runs my database instance.
> The Solaris 2.6 machine is an Ultra 1/170E with 192MB RAM
> The Solaris 2.5.1 machine is an Ultra 30 250MHz with 128 MB RAM
> My database has 18000 records and 30 100CHAR fields
> On Solaris 2.6 it takes 0.5 second to perform a simple select but on the faster
> Ultra 30 it take 5.0 seconds.
> Are there some settings for /etc/system that Solaris 2.5.1 needs to perform like
> Solaris 2.6
> The disk on the Ultra 30 is much faster than my Ultra 1/170E
It is very possible that Ultra 1/170E can fit the entire
table into RAM, while Ultra 30 cannot. Can you add more
RAM to Ultra 30 to see if it will work faster?