Divya,
Here are some of the statistics :
a) We are using Oracle 8i DB. The query (or the DBMS) takes only 6 seconds to return data to Perl.
So the query execution takes 6 seconds... How long does it take to get all the rows back in sqlplus (I mean how long does it take for sqlplus to get all 20K rows)?
c) So we conclude that it is mainly an issue with fetchrow especially when the number of records are high. We tried other possible options like
$stmt_handle->fetch() $stmt_handle->bind_columns() $stmt_handle->fetchall_arrayref() $stmt_handle->fetchrow_array() $stmt_handle->fetchall_hashref() @records = @{ $db_handle->selectall_arrayref($sql_stmt) };
Have you taken a look at RowCacheSize? If you are expecting 20K rows, does setting this parameter to 10000 help? Have you try tuning sqlnet (setting larger SDU and larger TDU)?
Regards,
Michael
