Link to home
Start Free TrialLog in
Avatar of Kinderly Wade
Kinderly WadeFlag for United States of America

asked on

Will the Where condition be better than the JOIN table condition?

Dear experts,

I've question with mysql query.  I want to process an online order which users will input the item number and the quantity that they wish to buy.

Will it be better that I store the item number and quantity into a temporary table and do a JOIN with the item number (item numbers are unique number) in my item table or I can select the columns that I need from item table and place all the item numbers provided by users in the where condition of a query?

User's input can be ranged from a single row to few thousand rows(maybe 10K on rare occasions).

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Nem Schlecht
Nem Schlecht
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial