[development] Guidelines for writing efficient SQL code

larry at garfieldtech.com larry at garfieldtech.com
Wed Aug 26 15:52:51 UTC 2009

This is a moot point anyway as of Drupal 7, as you shouldn't be quoting 
anything.  You should be using placeholders/prepared statements for all 
queries, and the database will deal with it.

--Larry Garfield

Pierre Rineau wrote:
> All I'm asking is Standard SQL, I don't blame you to use MySQL.
> Pierre.
> On Wed, 2009-08-26 at 10:34 -0400, Nancy Wichmann wrote:
>> Pierre Rineau wrote:
>>> If you test a integer field, use no quotes, if you test a varchar field,
>>> use quotes, that's it. Your DBMS will be smarter than you (except MySQL,
>>> but for kitten sake, do standard SQL, it will be easier for PostgreSQL
>>> user like me to port your code if needed).
>> Then why, Pierre, is the quoted version faster, by far?  At least in MySql.
>> Please stop disparaging MySql. The vast majority of sites use it, so it
>> can't be all bad.
>> Nancy E. Wichmann, PMP
>> Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King,
>> Jr.

More information about the development mailing list