Where clause issue etc
View Single Post
05-08-2008, 05:01 PM
Join Date: Dec 2007
Originally Posted by
Highway of Life
Have you run benchmarks against them? how do you know?
Running them side-by-side, you may not notice a difference, in-fact, you probably won't.
They may slow down by 0.01 seconds, which may seem insignificant, but that will make a big difference the more queries you have and the more traffic you have on your site that would cause these queries to run.
A savings of 0.01 seconds is significant on my sites. But regardless, itís a good idea to use correct practices, and xenon is correct regarding the usage of aliases.
Aliases would be needed on multiple table queries, but are not needed when querying a single table. :)
Itís not a *big* deal, but itís still good practice. ;)
What would you prefer then?
"The reasonable man adapts himself to the conditions that surround him... The unreasonable man adapts surrounding conditions to himself... All progress depends on the unreasonable man." - George Bernard Shaw
View Public Profile
Send a private message to Orc
Visit Orc's homepage!
Find More Posts by Orc