
islamabadi
New User
Nov 30, 2004, 2:35 PM
Post #1 of 1
(673 views)
|
|
Very slow performance with fetchrow_arrayref()
|
Can't Post
|
|
I have a Perl code where I am querying Oracle Database and then outputting the code to an html webpage with some regex expressions to format the output a certain way, etc. When I have a few records (<=20) the web page is super fast. When I have more that 20 records returned, the loop gets very slow and then after about 30 records it just stops. I have made sure that the code is not still querying the database. It is after the query result is returned in the fetchrow_arrayref() that the code gets stuck. Any pointer???? Thanks,
|