On Mon, Jun 21, 2004 at 07:37:50PM +0200, Leonardo Francalanci wrote: > > Oh. You didn't say thta. :-) > > Well, I wrote > " Doing a simple "SELECT SUM(MYFIELD) FROM MYTABLE" I noticed " > but don't worry ;)
Oh. Damned Mondays. I never liked 'em. :-( > > How much RAM does your machine have? If it's nearly all cached, > > you'll be CPU bound rather than disk bound. > > 1Gb. > > I'm using Solaris 8. > > The SUM() works as expected now (disks works a lot), but accessing by key > is very cpu-intense and still 0% work on disk. > > To sum up: table scans are very disk-intense (which make sense), > accessing by key leaves disk on idle (I see that it should not work > as with a table scan, but at least a little!) Hmm. -- 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]
