Multiple PHP MySQL simpler queries vs one single more complex query,

Question

Should I do single more complex MySQL query or multiple simpler queries with PHP?

For example

Simpler queries:

UPDATE image SET profile = 0 WHERE user_id = 1;

UPDATE image SET profile = 1 WHERE user_id = 1 AND id = 10;

One single more complex query:

UPDATE image
    SET profile = CASE id WHEN 10 THEN 1 ELSE 0 END
    WHERE user_id = 1;

1: What is fastest and most efficient?

2: What is considered to be best practice, or preferred method?

such a question has been asked many times before, please do some research before asking on SO — Abdelrhman Adel
– Abdelrhman Adel, Commented Jul 6, 2015 at 8:55
I can't think of a reason to use the 1-st option in this case. — Vatev
– Vatev, Commented Jul 6, 2015 at 8:58

Lalit Patel · Accepted Answer · 2015-07-06 09:41:35Z

1

One single query is fastest and most efficient

Besides the IF statement, MySQL also provides an alternative conditional statement called MySQL CASE. The MySQL CASE statement makes the code more readable and efficient. See more details... http://www.mysqltutorial.org/mysql-case-statement/

answered Jul 6, 2015 at 9:41

Lalit Patel

1081 silver badge9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Multiple PHP MySQL simpler queries vs one single more complex query,

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related