oln A. Baxter; Janet Goldstein
Cc: Dbi-Users
Subject: RE: performance problem with dbd oracle
After reading all the comments I modified the test to turn auto commit off
and commited once after the loop is over (not really necessary since orcale
will do an implicit commit for me once I disconnect). Sinc
Commit was spot on. I'd missed that.)
Tim.
> --
> Ron Reidy
> Sr DBA
> Array BioPharma, Inc.
>
>
> -Original Message-
> From: Tim To [mailto:[EMAIL PROTECTED]
> Sent: Fri 4/16/2004 5:22 PM
> To: Tim Bunce
> Cc: [EMAIL PROTECTED]
> Subjec
ly why it is so expensive.
>
> Other comments below:
>
> --
> Ron Reidy
> Sr. DBA
> Array BioPharma, Inc.
>
>
> -Original Message-
> From: Tim To [mailto:[EMAIL PROTECTED]
> Sent: Fri 4/16/2004 4:27 PM
> To: Lincoln A. Baxter; Janet Goldstein
> C
4 1:28 PM
> To: [EMAIL PROTECTED]; Tim Bunce
> Cc: [EMAIL PROTECTED]
> Subject: RE: performance problem with dbd oracle
>
>
> Sure the network issue exists...look at your $data_source var.
> You are requesting a SQL*Net connection.
>
> --
> Ron Reidy
> Sr DBA
> Arra
]
Subject:RE: performance problem with dbd oracle
Thanks Tim I will try that.
I am running all these tests on the same server - does the network latency
still apply? What else can I provide to get more help? Basically the app and
the environment didn't change I just ported everything from
idy
Sr. DBA
Array BioPharma, Inc.
-Original Message-
From: Tim To [mailto:[EMAIL PROTECTED]
Sent: Fri 4/16/2004 4:27 PM
To: Lincoln A. Baxter; Janet Goldstein
Cc: Dbi-Users
Subject:RE: performance problem with dbd oracle
Thanks for the suggestion.
I do realize that b
On Fri, Apr 16, 2004 at 11:07:04AM -0700, Tim To wrote:
> The performance problem is actually worse with the real app which I have
> ported from Linux mysql to Solaris oracle. The worst of the statements is
> executing a commit after three or so insert/update statement so I've created
> a couple of
PROTECTED];
> [EMAIL PROTECTED]
> Subject: Re: performance problem with dbd oracle
>
>
> On Fri, Apr 16, 2004 at 11:07:04AM -0700, Tim To wrote:
> > The performance problem is actually worse with the real app which I have
> > ported from Linux mysql to Solaris oracle. The worst
le related (i.e. within Oracle) it should
affect the pl/sql code the same way - shouldn't it??
Tim
> -Original Message-
> From: Lincoln A. Baxter [mailto:[EMAIL PROTECTED]
> Sent: Friday, April 16, 2004 3:01 PM
> To: Janet Goldstein
> Cc: Dbi-Users
> Subject: RE: pe
ill 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:
race??
Thanks again,
Tim
> -Original Message-
> From: Reidy, Ron [mailto:[EMAIL PROTECTED]
> Sent: Friday, April 16, 2004 7:47 AM
> To: Scott T. Hildreth
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: performance problem with dbd oracle
>
>
> And you can p
Tim To wrote:
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.
Are you inserting records i
ginal Message-
> From: Tim To [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 15, 2004 11:53 AM
> 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 w
: Tim To [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 15, 2004 11:53 AM
> 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 da
ity.
-
Ron Reidy
Senior DBA
Array BioPharma, Inc.
-Original Message-
From: Tim To [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 15, 2004 11:53 AM
To: [EMAIL PROTECTED]
Subject: performance problem with dbd oracle
Hi,
How can I improve performance when using oracle dbd?
On Thu, 15 Apr 2004, Tim To wrote:
> 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.
We just write out control and load
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
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
runni
18 matches
Mail list logo