MySQL Forums
Forum List  »  Full-Text Search

Select * vs Select Columns
Posted by: Lee Fairbanks
Date: July 10, 2014 12:15PM

SELECT *
FROM cw_products P INNER JOIN cw_skus S ON P.product_merchant_product_id = S.sku_merchant_sku_id
WHERE ( P.product_archive <> True AND P.product_merchant_product_id LIKE varSearch) OR (MATCH (P.product_name) AGAINST (varSearch IN NATURAL LANGUAGE MODE) AND P.product_archive <> True ) OR (MATCH (P.product_description) AGAINST (varSearch) AND P.product_archive <> True)

When I Select *, it runs almost instantly but when I list only the columns I need, it's painfully slow which is odd. Any suggestions?

Options: ReplyQuote


Subject
Views
Written By
Posted
Select * vs Select Columns
2767
July 10, 2014 12:15PM
1493
July 13, 2014 04:50PM
1271
July 14, 2014 10:19AM
1482
July 14, 2014 10:23AM
1399
July 14, 2014 11:16AM
1336
July 14, 2014 11:20AM
1412
July 14, 2014 01:37PM
1401
July 15, 2014 09: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.