IMHO the problem is in this condition ...Field5 LIKE '%John'...
Can you remove it from query and try again? Mikhail. ----- Original Message ----- From: "David Bordas" <[EMAIL PROTECTED]> To: "Mikhail Entaltsev" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, August 27, 2002 2:49 PM Subject: Re: Slow select query, need some clues to speed it up please ... > ----- Original Message ----- > From: "Mikhail Entaltsev" <[EMAIL PROTECTED]> > > ME> Can you send result of the query, please: > ME > select * from MyTable PROCEDURE ANALYSE(); > > Here you are : > mysql> select * from MyTable PROCEDURE ANALYSE(); > +--------------+----------+----------+----------------+-------+------------- > ----------+---------+------------------------------+ > |Field_name |Min_length|Max_length|Empties_or_zeros|Nulls > |Avg_value_or_avg_length|Std |Optimal_fieldtype > | > +--------------+----------+----------+----------------+-------+------------- > ----------+---------+------------------------------+ > |MyTable.Field1| 1| 7 | 0 | > 0|3988722.5930 |0.0000 |MEDIUMINT(7) UNSIGNED NOT > NULL| > |MyTable.Field2| 1| 7 | 573688 | > 0|3212734.0355 |0.0000 |MEDIUMINT(7) UNSIGNED NOT > NULL| > |MyTable.Field3| 1| 47 | 204 | > 0|8.2074 |NULL |VARCHAR(47) NOT NULL > | > |MyTable.Field4| 1| 50 | 71 | > 0|24.5052 |NULL |VARCHAR(50) NOT NULL > | > |MyTable.Field5| 1| 51723 | 1 | > 0|174.5134 |NULL |TEXT NOT NULL > | > |MyTable.Field6| 12| 14 | 3809075 | > 0|63688541485.2995 |0.0000 |BIGINT(14) UNSIGNED NOT NULL > | > |MyTable.Field7| 1| 4 | 0 | > 0|1646.5029 |2596.7715 |SMALLINT(4) UNSIGNED NOT > NULL | > +--------------+----------+----------+----------------+-------+------------- > ----------+---------+------------------------------+ > > NB: > > Table desc : > > CREATE TABLE MyTable ( > > Field1 int(10) unsigned NOT NULL auto_increment, > > Field2 int(10) unsigned NOT NULL default '0', > > Field3 varchar(50) NOT NULL default '', > > Field4 varchar(50) NOT NULL default '', > > Field5 text NOT NULL, > > Field6 bigint(20) NOT NULL default '0', > > Field7 int(10) unsigned NOT NULL default '0', > > PRIMARY KEY (Field1), > > KEY ReplyTo_Numero (Field2,Field1), > > KEY indexF (Field7,Field2,Field6) > > ) TYPE=MyISAM PACK_KEYS=1; > > Thanks > David > --------------------------------------------------------------------- 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
