Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

Re: performance problem with oracle dbd

by dws (Chancellor)
on Apr 15, 2004 at 17:35 UTC ( [id://345466]=note: print w/replies, xml ) Need Help??


in reply to performance problem with oracle dbd

We have an urgent performance problem where inserting data into an Oracle 9i database using DBI/DBD oracle is at least five times slower than stright sql using sqlplus.

Were this to drop in my lap, the first thing I'd do is make sure that I'm doing an "apples to apples" comparision. I.e., am I really issuing the same stream of requests to Oracle across the wire when using DBI that I am when using SQL*Plus.

In the meantime, can you show us a representative chunk of code that is inserting data?

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others imbibing at the Monastery: (5)
As of 2024-03-28 08:53 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found