Although MySQL is a fast DBMS all-round, there are some things it does particularly well. We have covered the majority here, but there is one particular optimisation you should be aware of, and that is that the following syntax is particularly fast:
SELECT foo FROM bar WHERE baz IN (constant1, constant2, constant3);
This holds true even if you have a fairly long list of constants for the IN clause.
Copyright 2012 Future Publishing Limited (company
registered number 2008885), a company registered
in England and Wales whose registered office is at