[development] Guidelines for writing efficient SQL code

[Pierre Rineau]

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.
>