[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
Automatic Email Organization without missing anything!