CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
Search Posts SEARCH
Who's Online WHO'S
Log in LOG

Home: Perl Programming Help: Advanced:
Very slow performance with fetchrow_arrayref()


New User

Nov 30, 2004, 2:35 PM

Post #1 of 1 (1139 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????



Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives