Can you send result of the query, please: select * from MyTable PROCEDURE ANALYSE();
Mikhail. ----- Original Message ----- From: "David Bordas" <[EMAIL PROTECTED]> To: "Mikhail Entaltsev" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, August 27, 2002 2:13 PM Subject: Re: Slow select query, need some clues to speed it up please ... > From: "Mikhail Entaltsev" <[EMAIL PROTECTED]> > > ME> Check the query plan > ME> EXPLAIN SELECT Field1,Field2,Field3,Field4,Field5,Field6,Field7 FROM > ME> MyTable WHERE > ME> Field7=15 AND Field2=0 AND (Field3 LIKE '%John%' OR Field4 LIKE '%John%' > OR > ME> Field5 LIKE '%John') ORDER BY Field6 LIMIT 0,20; > > | table | type | possible_keys | key | key_len | > ref | rows | Extra | > +--------+------+-----------------------+--------+---------+-------------+-- > -----+------------+ > | MyTable | ref | ReplyTo_Numero,indexF | indexF | 8 | const,const > | 51145 | where used | > > 1 row in set (0.01 sec) > > 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
