On Mon, Oct 22, 2001 at 08:02:49AM +0100, Ronan Minogue wrote: > Jeremy, > > Firstly thank you for the reply. > > On the MySql web site there are benchmark response times provided > for the execution of queries on NT 4. e.g. reading 2,000,000 rows > by index requiring 367 seconds. > > Are you aware of any comparable test on Linux?
You can run the benchmarks yourself on Linux if you'd like. The benchmark software is part of the MySQL distribution. But those speeds are easily attainable on modern hardware. The numbers you actually see will depend heavily on your setup, of course, but I just ran a big select (450,000 rows) on a table with 150 million rows. I was done in about 50 seconds. I really haven't optimized for that case, since we never run queries like that. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 46 days, processed 1,018,067,398 queries (253/sec. avg) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
