Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
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?
[1nickt]: Corion using Moose will hardly reduce the number of dependencies or time to install DT !
[davido]: That's like wishing that your motorcycle came with a sherman tank as a trailer.
[Corion]: davido: No, more like my one sherman tank had a second sherman tank tied to its back ;)

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (8)
As of 2017-03-23 15:34 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Should Pluto Get Its Planethood Back?



    Results (289 votes). Check out past polls.