phpComplete.com has posted a new tutorial this morning covering MySQL and how to optimize the queries that you use with it.

With all that is going on (with the new site restructuring), I felt that I should buckle down and at least get a new tutorial out. In going back through all my old tutorials, I noticed a severe lack of MySQL Tutorials. Recently WDVL (www.wdvl.com) had an excellent 2 part article on optimizing MySQL and the queries you created for it. However they did leave some useful things out, and I wish to present these ideas here.

He covers some of the essentials, mainly about choosing the right kind of field type for what you want to do. Even I've been guilty (many times) of using an incorrect type or creating a field too large. Some of the suggestions he mentions are: Keep Columns Short, Use ENUM wherever possible, and Put *BLOB and *TEXT Types into seperate tables. Read on for more...