On Fri, 2004-04-16 at 09:10, Jones Robert Civ TTMS Keesler wrote: > Code? Also, using sqlloader, the native program for inserting data, > has been cited as being faster than using DBI for straight insertions.
If you are not using bind variables (placeholders for your data), then it will be quite slow, since every statement would then have to be parsed by oracle. Thats why you were asked for your code. Lincoln > > -----Original Message----- > From: Tim To [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 15, 2004 12:53 PM > To: [EMAIL PROTECTED] > Subject: performance problem with dbd oracle > > > Hi, > How can I improve performance when using 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. > Any suggestion is appreciated. > > DBD::oracle 1.15 > DBI 1.4 > PERL 5.8.0 > running on solaris 9 > Oracle 9.2.0.1 > > Thanks, > Tim To >
