NYCPHP Meetup

[David Krings]

David Krings wrote:
> Hi!
> 
> Which one is faster: PHP array_unique or SQL DISTINCT ?
> 

OK, while I still like to know what the answer is, the DISTINCT wasn't 
the culprit, but the way I join the tables. I ran the query across only 
two tables and with that got millions of records when I expected only a 
few hundred.
I guess it is time to learn some more SQL and not just go for broke and 
run queries without knowing what they really do. Worked fine in the test 
system with only a dozen records in each table. My approach apparently 
doesn't scale well.

David