--- Eugene Krivdyuk <[EMAIL PROTECTED]> 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
