> 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 ?
>
I tried before with a small test case with no success. I will attempt again
with a larger dataset and hopefully it will pop-up.
ryan
---------------------------------------------------------------------
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
