[development] Guidelines for writing efficient SQL code

Nancy Wichmann nan_wich at bellsouth.net
Wed Aug 26 14:34:24 UTC 2009

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,

More information about the development mailing list