Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

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

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

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (4)
As of 2021-01-22 04:10 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Notices?