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