18.2.25 Know MySQL's strengthsThis is NOT the latest copy of this book; click here for the latest version.
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.
|
Want to see this stuff in print? PHP in a Nutshell takes the core topics covered here, adds in thousands of edits from the editorial team and myself, and combines them to make an unbeatable reference for PHP programmers at all levels.
My latest book has hundreds more tips on how to use PHP, Apache, and MySQL, plus Perl, Python, shell scripts, performance tuning, and more!
|
