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.
~~~~~~~~~~~~~~~
I like chicken.
|
---|
In Section
Seekers of Perl Wisdom