Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Re^2: Query takes 895ms in TOAD but 42s in DBI

by joec_ (Scribe)
on Dec 02, 2008 at 16:31 UTC ( #727458=note: print w/ replies, xml ) Need Help??


in reply to Re: Query takes 895ms in TOAD but 42s in DBI
in thread Query takes 895ms in TOAD but 42s in DBI

Thanks for the replies. I will get round to profiling it when i can get the module installed.

I cant use coalesce as i dont have access to the schema. Even just doing the query without printing to stdout or files takes 42 seconds.

regards, Joe


Comment on Re^2: Query takes 895ms in TOAD but 42s in DBI
Replies are listed 'Best First'.
Re^3: Query takes 895ms in TOAD but 42s in DBI
by dragonchild (Archbishop) on Dec 02, 2008 at 22:38 UTC
    COALESCE is a function you put into your query that takes the first non-NULL value.

    As for what's going on ... You said this returns a cursor. What happens in TOAD if you subsequently run through all the rows in the cursor? I suspect that DBD::Oracle is doing just that while TOAD isn't.


    My criteria for good software:
    1. Does it work?
    2. Can someone else come in, make a change, and be reasonably certain no bugs were introduced?

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (9)
As of 2015-07-30 07:31 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (270 votes), past polls