NYCPHP Meetup

NYPHP.org

[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!