Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Re: Re: performance problem with oracle dbd

by tito (Novice)
on Apr 15, 2004 at 17:42 UTC ( [id://345470]=note: print w/replies, xml ) Need Help??


in reply to Re: performance problem with oracle dbd
in thread performance problem with oracle dbd

Thanks for the reply, The performance problem is worse with the actual app. The five times performance slow down was verified by running two stripped down tests with identical insert statements and commit frequencies. One test was coded using PL/SQL looping construct and the other using perl. I will go and take a look at the documentation and see how one can set the buffer and windows sizes for DBD since I've not set those parameters for DBD.

Replies are listed 'Best First'.
Re: Re: Re: performance problem with oracle dbd
by perrin (Chancellor) on Apr 15, 2004 at 19:47 UTC
    The PL/SQL code doesn't have any network overhead, so naturally it will be faster. PL/SQL is not a general-purpose language, so it can't do the same things Perl can, but if it meets your needs and speed is extremely important for this project, I'd say use it.
Re: performance problem with oracle dbd
by Roy Johnson (Monsignor) on Apr 15, 2004 at 18:23 UTC
    PL/SQL is faster than DBD because it's all executed on the database side, rather than using multiple transactions. There is nothing wrong with throwing a chunk of PL/SQL into your Perl, if that's appropriate for what you want to do. It works fine.

    The PerlMonk tr/// Advocate

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others admiring the Monastery: (6)
As of 2024-03-29 13:01 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found