|Think about Loose Coupling|
Re: (OT) perl, memory and mysqlby misterb101 (Sexton)
|on Feb 10, 2006 at 18:48 UTC||Need Help??|
rnahi is right. If you want to see how many rows are effected and how the joins are done execute a
in your command line mysql client. Any query that has table joins like 'ALL' are bad news. These are the cartesian product joins rnahi talks about.
for more information about this check for instance http://dev.mysql.com/doc/refman/4.1/en/query-speed.html
if the explain query gives you a reasonable amount of rows and joins and you still have a problem with DBI, return to the monastry!