> Oh. You didn't say thta. :-) Well, I wrote " Doing a simple "SELECT SUM(MYFIELD) FROM MYTABLE" I noticed " but don't worry ;)
> 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!) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
