in reply to
Re^2: DBIx and ManyToMany Relationships
in thread DBIx and ManyToMany Relationships
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.