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
2914
July 10, 2014 12:15PM
1646
July 13, 2014 04:50PM
1365
July 14, 2014 10:19AM
1568
July 14, 2014 10:23AM
1475
July 14, 2014 11:16AM
1435
July 14, 2014 11:20AM
1513
July 14, 2014 01:37PM
1472
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.