On Mon, Jun 21, 2004 at 07:10:59PM +0200, Leonardo Francalanci wrote: > > Hard to say, but in a table scan the CPU does have a lot of work to > > do. It needs to do about 16,000,000 comparisons (based on your info). > > Why comparison? It's a sum...
Oh. You didn't say thta. :-) > And the table is not small: 272,000,000 bytes! > > And disk is very low (almost 0%) How much RAM does your machine have? If it's nearly all cached, you'll be CPU bound rather than disk bound. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ [book] High Performance MySQL -- http://highperformancemysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
