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.
