Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re: Re: Perl/CGI + MySQL: How many calls is too many?

by oakbox (Chaplain)
on Jan 09, 2003 at 08:58 UTC ( [id://225488]=note: print w/replies, xml ) Need Help??


in reply to Re: Perl/CGI + MySQL: How many calls is too many?
in thread Perl/CGI + MySQL: How many calls is too many?

In MySQL, in my current project, it was the Group by's that were killing me. It's much faster to just slurp all of that information into a hash ref and do the grouping in Perl. The same goes for SUM and COUNT calls. If you are doing more than one or two of these calls, you pretty much NEED to pull that data into Perl and do the additions there.

oakbox

  • Comment on Re: Re: Perl/CGI + MySQL: How many calls is too many?

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others having a coffee break in the Monastery: (4)
As of 2024-04-19 23:26 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found