[nycphp-talk] PHP array_unique vs. SQL DISTINCT
David Krings
ramons at gmx.net
Sun Jun 3 20:40:55 EDT 2007
Adrian Noland wrote:
> The key to speedy SQL is in the indexes. Without an index the SQL engine
> iterates over every row. With an index it automagically grabs the
> correct value.
This is really an eyeopener. After indexing all those columns that come
up in some selects running the same query that took over 30 minutes
(that's when I hit the reset button) now takes 26 seconds.
This is plain awesome! Thanks for making me less dumb.
David
More information about the talk
mailing list