php - MySQL Performance - "IN" Clause vs. Equals (=) for a Single Value

Question

(This question already has answers here): question from:https://stackoverflow.com/questions/9926433/mysql-performance-in-clause-vs-equals-for-a-single-value

Answer 1

Neither of them really matter in the big scope of things. The network latency in communicating with the database will far outweigh either the count($object_ids) overhead or the = vs IN overhead. I would call this a case of premature optimization.

You should profile and load-test your application to learn where the real bottlenecks are.