Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW

Re: A profiling surprise ...

by chrism01 (Friar)
on May 26, 2008 at 01:21 UTC ( #688461=note: print w/replies, xml ) Need Help??

in reply to A profiling surprise ...

Just a general comment re my experiences with similar issues.
I discovered that just because a DB has built-in fns to do handy stuff like eg sum(), group by for example, it doesn't necessarily mean they are efficiently coded.
I actually improved a prog by order of magnitude iirc, by in fact doing relatively simple SELECTS instead, and doing those fns in Perl.
Its worth testing stuff like that instead of assuming.
I'd also go with checking/setting indexes as advised above.

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (4)
As of 2021-10-28 20:32 GMT
Find Nodes?
    Voting Booth?
    My first memorable Perl project was:

    Results (96 votes). Check out past polls.