Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

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?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://973261]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (5)
As of 2014-08-21 03:29 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (127 votes), past polls