MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: MySQL Performance Issue: String search in multiple columns/tables
Posted by: Rick James
Date: March 20, 2015 11:27PM

For starters, turn the ORs into UNIONs.

Get rid of LEFT unless you know you need it.

Once you have the UNIONs, you can get rid of some of the tables in some of the cases.

Also consider using FULLTEXT.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
MySQL Performance Issue: String search in multiple columns/tables
Michael Alterio
March 19, 2015 01:35PM
Re: MySQL Performance Issue: String search in multiple columns/tables
Peter Brawley
March 19, 2015 11:59PM
Re: MySQL Performance Issue: String search in multiple columns/tables
Rick James
March 20, 2015 11:27PM


Sorry, you can't reply to this topic. It has been closed.

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.