[development] Guidelines for writing efficient SQL code

Pierre Rineau pierre.rineau at makina-corpus.com
Wed Aug 26 14:37:41 UTC 2009

All I'm asking is Standard SQL, I don't blame you to use MySQL.


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