Re: Time difference for a query by changing one field?
Posted by: Peter Brawley
Date: November 20, 2018 10:09AM

Not much optimisation possible with a MyISAM table. More possibilities with InnoDB, esp. with 5.7 and 8.0.

The OR in the Where clause will slow things down. With a million rows and MyISAM, 2.3 sec would be considered good.

The Explain result might yield more info.

Options: ReplyQuote


Subject
Written By
Posted
Re: Time difference for a query by changing one field?
November 20, 2018 10:09AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.