Perl Monk, Perl Meditation | |
PerlMonks |
Re: performance problem with oracle dbdby dws (Chancellor) |
on Apr 15, 2004 at 17:35 UTC ( [id://345466]=note: print w/replies, xml ) | Need Help?? |
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?
In Section
Seekers of Perl Wisdom
|
|