http://qs321.pair.com?node_id=194109


in reply to Big database queries

Sounds an awful lot like a Cartesian Product (which is an overly fancy way of saying the you have probably underqualified your "where" clause). Just for laughs, do a select count(*) from each of the tables involved. If there are nowhere near as many rows as 60 million then you probably need to add more joins to your "where" clause.

~~~~~~~~~~~~~~~
I like chicken.