In the last episode (Jul 29), Asif Iqbal said: > On my E420R with 4 x 450MHz and 4 gb mem what mysql variables should I need to > play with to improve the following output > > mysql> SELECT BENCHMARK(1000000,ENCODE("hello","goodbye")); > +----------------------------------------------+ > | BENCHMARK(1000000,ENCODE("hello","goodbye")) | > +----------------------------------------------+ > | 0 | > +----------------------------------------------+ > 1 row in set (2.89 sec)
The only thing that will improve that specific query is a faster CPU. The number of CPUs and the amount of RAM is unimportant. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]