Hmmm.... this sounds suspiciously like making multiple calls to the database, rather than gathering all the data in one query...
(In CGI-land, I got a 25-minute sequence of Perl loops and multiple SQL calls down to one 7 second call and 8 minutes of post-processing (on 150,000 records over 18 tables))
OK - is there a way of creating the SQL query at cole-level [based on a variety of parameters, and then passing it down to the DBIx connector to make the actual query?
-- Ian Stuart
A man depriving some poor village, somewhere, of a first-class idiot.