Hi!
>>>>> "Heikki" == Heikki Tuuri <[EMAIL PROTECTED]> writes:
Heikki> Hi!
Heikki> I checked that in the COUNT(*) below InnoDB does
Heikki> not fetch the whole row if it does the query through
Heikki> a secondary index. It may sometimes have to
Heikki> fetch it to determine if the row should be visible
Heikki> in the current consistent read, the trx id is
Heikki> stored in the whole row in the primary key index.
Heikki> But Ryan said that queries were CPU-bound,
Heikki> and fetching a million rows through a primary key
Heikki> should at most take 10 s.
Heikki> Regards,
Heikki> Heikki
Heikki> http://www.innodb.com
This sounds like we would need a test case to solve this...
Ryan, any change you could provide us with a script that would
generate data for a testcase ?
Regards,
Monty
---------------------------------------------------------------------
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