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
Array BioPharma, Inc.
-Original Message-
From: Tim
are using bind variables.
Thanks for all your comments again,
Tim To
-Original Message-
From: Reidy, Ron [mailto:[EMAIL PROTECTED]
Sent: Saturday, April 17, 2004 1:26 PM
To: [EMAIL PROTECTED]; Lincoln A. Baxter; Janet Goldstein
Cc: Dbi-Users
Subject: RE: performance problem with dbd oracle
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]
Subject: RE: performance problem with dbd oracle
Thanks Tim I
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). Since one
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
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 bind
]
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 linux
Code? Also, using sqlloader, the native program for inserting data,
has been cited as being faster than using DBI for straight insertions.
-Original Message-
From: Tim To [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 15, 2004 12:53 PM
To: [EMAIL PROTECTED]
Subject: performance
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
Tim,
What performance problems are you having exactly? Did you run a 10046 trace? Are you
passing the {ora_check_sql = 0} in your prepare() call?
Also, I would suggest you look into SQL*Loader. Nothing you ever write in Perl will
give you the insert speed you will get with this utility.
On Fri, 2004-04-16 at 09:24, Reidy, Ron wrote:
Tim,
What performance problems are you having exactly? Did you run a 10046 trace? Are
you passing the {ora_check_sql = 0} in your prepare() call?
Also, I would suggest you look into SQL*Loader. Nothing you ever write in Perl will
give
problem with dbd oracle
On Fri, 2004-04-16 at 09:24, Reidy, Ron wrote:
Tim,
What performance problems are you having exactly? Did you run a 10046 trace? Are
you passing the {ora_check_sql = 0} in your prepare() call?
Also, I would suggest you look into SQL*Loader. Nothing you ever write
-
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 perform direct inserts.
-
Ron Reidy
Senior DBA
Array BioPharma, Inc
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
(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: performance problem with dbd oracle
On Fri
: 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 of the
statements is
executing a commit after three or so insert
16 matches
Mail list logo
