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 D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped> | http://jeremy.zawodny.com/
[book] High Performance MySQL -- http://highperformancemysql.com/