<snip> > On my p4 2gig > > mysql> SELECT BENCHMARK(1000000,ENCODE("hello","goodbye")); > +----------------------------------------------+ > | BENCHMARK(1000000,ENCODE("hello","goodbye")) | > +----------------------------------------------+ > | 0 | > +----------------------------------------------+ > 1 row in set (0.86 sec) <snip> > I ran this benchmark on my pIII 500 and was wondering what everyone else > was getting? > > mysql> SELECT BENCHMARK(1000000,ENCODE("hello","goodbye")); > > +----------------------------------------------+ > | BENCHMARK(1000000,ENCODE("hello","goodbye")) | > +----------------------------------------------+ > | 0 | > +----------------------------------------------+ > 1 row in set (2.59 sec) > Dual Athlon 1900+ RedHat 8 512MB RAN (Mysql 3.23.56-log - development box so only 1 user) mysql> select BENCHMARK(1000000,ENCODE("hello","goodbye")); +----------------------------------------------+ | BENCHMARK(1000000,ENCODE("hello","goodbye")) | +----------------------------------------------+ | 0 | +----------------------------------------------+ 1 row in set (0.61 sec)
Dual P3-600 Redhat 7.3 1GB RAM(Mysql 3.23.56-log - busy server) mysql> select BENCHMARK(1000000,ENCODE("hello","goodbye")); +----------------------------------------------+ | BENCHMARK(1000000,ENCODE("hello","goodbye")) | +----------------------------------------------+ | 0 | +----------------------------------------------+ 1 row in set (2.61 sec) -- Woody In a world without boundaries why do we need Gates and Windows? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]