Re: Inefficient use of index (was: Big difference in MyISAM and InnoDB SELECT speed)

Janusz Krzysztofik wrote: ... I am trying to optimize MySQL (3.23.49 from Debian stable) setup for ASPseek application. I decided to try InnoDB in order to be able to update tables while performing time consuming selects. After converting all tables to InnoDB I noticed a big difference in

Big difference in MyISAM and InnoDB SELECT speed

Hello, I am trying to optimize MySQL (3.23.49 from Debian stable) setup for ASPseek application. I decided to try InnoDB in order to be able to update tables while performing time consuming selects. After converting all tables to InnoDB I noticed a big difference in processing speed of one of the

RE: Big difference in MyISAM and InnoDB SELECT speed

: lundi 24 novembre 2003 13:58 A : [EMAIL PROTECTED] Objet : Big difference in MyISAM and InnoDB SELECT speed Hello, I am trying to optimize MySQL (3.23.49 from Debian stable) setup for ASPseek application. I decided to try InnoDB in order to be able to update tables while performing time consuming

Inefficient use of index (was: Big difference in MyISAM and InnoDB SELECT speed)

an EXPLAIN on your query ? May be an index on (origin,status,deleted) could help. Marc. -Message d'origine- De : Janusz Krzysztofik [mailto:[EMAIL PROTECTED] Envoy : lundi 24 novembre 2003 13:58 A : [EMAIL PROTECTED] Objet : Big difference in MyISAM and InnoDB SELECT speed Hello

Re: Inefficient use of index (was: Big difference in MyISAM and InnoDB SELECT speed)

PROTECTED] Envoy : lundi 24 novembre 2003 13:58 A : [EMAIL PROTECTED] Objet : Big difference in MyISAM and InnoDB SELECT speed Hello, I am trying to optimize MySQL (3.23.49 from Debian stable) setup for ASPseek application. I decided to try InnoDB in order to be able to update tables while

RE: Inefficient use of index (was: Big difference in MyISAM and InnoDB SELECT speed)

difference in MyISAM and InnoDB SELECT speed) Marc, Thank you for your prompt answer. I run EXPLAIN in both cases and got: MyISAM (fast): mysql explain select url_id from urlword where deleted=0 and status=200 and origin=1

Re: Inefficient use of index (was: Big difference in MyISAM and InnoDB SELECT speed)

Hi, You are not using any indicies, because there aren't any that could be used in this query. Try adding an index on (status,deleted) I wonder: how many possible different values would such an index return? If this is a (very) low value, won't the index make things slower (if it's being

Re: Inefficient use of index (was: Big difference in MyISAM and InnoDB SELECT speed)

Martijn Tonies wrote: Hi, You are not using any indicies, because there aren't any that could be used in this query. Try adding an index on (status,deleted) I wonder: how many possible different values would such an index return? mysql select distinct status, deleted from urlword;

Re: Inefficient use of index (was: Big difference in MyISAM and InnoDB SELECT speed)

Hi, You are not using any indicies, because there aren't any that could be used in this query. Try adding an index on (status,deleted) I wonder: how many possible different values would such an index return? mysql select distinct status, deleted from urlword;