At 12:53 -0700 5/16/03, Jeremy Zawodny wrote:
>On Fri, May 16, 2003 at 03:43:09PM -0400, Vincent Ferretti wrote:
>> I have created two identical tables (same structure, same content) but one
>> is an innodb table and the other is myIsam.
>>
>> CREATE TABLE my_table (
>> id INT(10) UNSIGNED NOT NULL,
>> chromatogramID INT(10) UNSIGNED,
>> sequence TEXT,
>> seqQuality TEXT,
>> UNIQUE (chromatogramID),
>> PRIMARY KEY (id)
>> );
>>
>> I've put with LOAD DATA 388896 records for a total of 1.3 GIG
>>
>> The same query
>>
>> SELECT COUNT(id) from my_table
>>
>> takes 0.17 for the myIsam and 1min 40 sec for the innnodb version. Worst,
>> when I query again, it could take up to 6 min to give the same result with
>> innodb.
>
>Have you seen the part of the InnoDB manual that describes why COUNT()
>queries are slow?
I don't understand why that applies, if I'm looking at the same section.
It pertains to COUNT(*), but the question above is for COUNT(col_name).
Vincent, are you actually issuing the query shown above, or are you really
using COUNT(*)?
>--
>Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
><Jeremy@stripped> | http://jeremy.zawodny.com/
>
>MySQL 4.0.8: up 102 days, processed 3,193,299,829 queries (361/sec. avg)
>
--
Paul DuBois
http://www.kitebird.com/
sql, query
