DBD::Oracle question?

Hi ALL. Is there a relation between the version of
DBD::Oracle and Oracle 10g.
The performance of executing the SQL statements is low
comparing to mysql performance.
Can any body advice me what to do to avoid this
performance issue

Regards,
Dakka, Rami




____________________________________________________________ ________________________
Don't get soaked. Take a quick peak at the forecast
with the Yahoo! Search weather shortcut.
http://tools.search.yahoo.com/shortcuts/#loc_weather

Re: DBD::Oracle question?

On 2007/02/26 Mon 02:20:25 , rami doqa wrote:
> Hi ALL. Is there a relation between the version of
> DBD::Oracle and Oracle 10g.
> The performance of executing the SQL statements is low
> comparing to mysql performance.
> Can any body advice me what to do to avoid this
> performance issue

What DBD::Oracle version are you using ? Performance issues may be caused
by incorrect Perl code, bad server configuration, network problems, etc.

Can you post your Perl code here ?


--
WBR, Eugene Krivdyuk

Re: DBD::Oracle question?

--- Eugene Krivdyuk wrote:

> On 2007/02/26 Mon 02:20:25 , rami doqa wrote:
> > Hi ALL. Is there a relation between the version of
> > DBD::Oracle and Oracle 10g.
> > The performance of executing the SQL statements is
> low
> > comparing to mysql performance.
> > Can any body advice me what to do to avoid this
> > performance issue
>
> What DBD::Oracle version are you using ? Performance
> issues may be caused
> by incorrect Perl code, bad server configuration,
> network problems, etc.
>
> Can you post your Perl code here ?
>
>
> --
> WBR, Eugene Krivdyuk
>
>

# my perl code:

$self->{dbh} = DBI->connect ($source,
$username,
$pass, {
AutoCommit => 1,
ChopBlanks => 1,
RaiseError => 1,
PrintError => 1, LongReadLen => 5242880,
LongTruncOk => 0, });

$self->{dbh}->{ora_ph_type} = 96 if defined
$self->{dbh}; # ORA_CHAR

# inside functions:

my $sql = 'select a.x , b.y from a , b where a.bid =
b.id..' # example
my $arr_ref = [];
$arr_ref = $self->{dbh}->selectrow_array($sql);
#...etc



____________________________________________________________ ________________________
Don't get soaked. Take a quick peak at the forecast
with the Yahoo! Search weather shortcut.
http://tools.search.yahoo.com/shortcuts/#loc_weather

Re: DBD::Oracle question?

On Mon, Feb 26, 2007 at 12:32:21PM +0200, Eugene Krivdyuk wrote:
> On 2007/02/26 Mon 02:20:25 , rami doqa wrote:
> > Hi ALL. Is there a relation between the version of
> > DBD::Oracle and Oracle 10g.
> > The performance of executing the SQL statements is low
> > comparing to mysql performance.
> > Can any body advice me what to do to avoid this
> > performance issue
>
> What DBD::Oracle version are you using ? Performance issues may be caused
> by incorrect Perl code, bad server configuration, network problems, etc.
>
> Can you post your Perl code here ?

Ideally as a very small self-contained example that other people can run.
Include the table definitions and server hardware and software config info.
(Also read http://www.catb.org/~esr/faqs/smart-questions.html)

Tim.

p.s. To anyone thinking of commenting on this thread, please avoid
knee-jerk statements like "Oracle is bound to be slower than MySQL."

RE: :Oracle question?

Yes - tune your design and application code. MySQL !=3D Oracle in any
way.

--
Ron Reidy
Lead DBA
Array BioPharma, Inc

-----Original Message-----
From: rami doqa [mailto:rod082@yahoo.com]=20
Sent: Monday, February 26, 2007 3:20 AM
To: dbi-users@perl.org
Subject: DBD::Oracle question?

Hi ALL. Is there a relation between the version of
DBD::Oracle and Oracle 10g.
The performance of executing the SQL statements is low
comparing to mysql performance.
Can any body advice me what to do to avoid this
performance issue

Regards,
Dakka, Rami



=20
____________________________________________________________ ____________
____________
Don't get soaked. Take a quick peak at the forecast
with the Yahoo! Search weather shortcut.
http://tools.search.yahoo.com/shortcuts/#loc_weather

This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
or use of the contents of this information is prohibited. Please notify =
the
sender of the delivery error by replying to this message, or notify us =
by
telephone (877-633-2436, ext. 0), and then delete it from your system.