Re: HELP ! PL/SQL program works fine but slows down more and more

esha1_at_cix.compulink.co.uk ("Mike Ziemann East Su") wrote:

>Hi,
>I have written a pl/sql program which reads data from a table and then
>inserts rows into a new table depending on the data in the original table.
 

>I am using tables of varchar2 to simulate arrays and have some large
>cursor select statements , I am also using the new integer type
>pls_integer which is supposed to be a lot faster.
 

>The program runs fine at first and produces a 1000 rows in the output
>table after a few seconds, but the longer it carries on the more it slows
>down. Eventually it appears to come to a practical stand-still.
>The data is fairly consistent and so I can't work out why this is
>happening, can anybody help ?

>Mike.

Are you using PLSQL tables to buffer records in memory ? This would explain why everything slows down after 1000 records or so. I do similar things without loading records into PLSQL tables and speed doesn't degrade. Received on Sat Aug 24 1996 - 00:00:00 CEST