[development] Guidelines for writing efficient SQL code

[Nancy Wichmann]

I am far from a MySql expert, as I am sure many on this list can attest to. But I have seen one thing that seems to make a big difference on some occasions and possibly somone can illuminate me on why. That is a numeric (say int(11)) index is used with "WHERE abc = 123" seems to be considerably slower than "WHERE abc = '123'", as explained by ANALYZE. Yet, we Drupallers mostly use the non-quoted version.

Nancy E. Wichmann, PMP
 
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.