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
2661
July 10, 2014 12:15PM
1407
July 13, 2014 04:50PM
1219
July 14, 2014 10:19AM
1440
July 14, 2014 10:23AM
1352
July 14, 2014 11:16AM
1274
July 14, 2014 11:20AM
1352
July 14, 2014 01:37PM
1360
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.