From: "Philip Olson" <[EMAIL PROTECTED]>
> They're very useful. Also, regarding SQL, don't do "SELECT * ..." all the
> time as it's overkill if not all fields are being used.
And, in fact, doing a "SELECT *" ends up precluding most optimizations
within a query engine! Selecting only what you really need can give speedups
in queries in the order of 3 orders of magnitude (where the query results
can be satisfied via indices).
Mark [EMAIL PROTECTED]
Former (and still occasionally) Oracle performance guy.
-----------
"When the unknown is thought to be unknowable, gaps in knowledge are too
readily filled by fancy, so long as the fancy is consistent with faith." --
Sherwin B. Newland, M.D., "The Mysteries Within".
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
