Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine

Re^3: DBIx and ManyToMany Relationships

by kiz (Monk)
on May 30, 2012 at 11:22 UTC ( #973261=note: print w/replies, xml ) Need Help??

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.
  • Comment on Re^3: DBIx and ManyToMany Relationships

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://973261]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (2)
As of 2018-02-25 22:23 GMT
Find Nodes?
    Voting Booth?
    When it is dark outside I am happiest to see ...

    Results (315 votes). Check out past polls.