Re: DBD::Oracle question?


--- Eugene Krivdyuk <ekrivdyuk@xxxxxxxxx> 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,
LongTrun*** => 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
.

Quantcast