HELP ! PL/SQL program works fine but slows down more and more
From: Mike Ziemann East Su <esha1_at_cix.compulink.co.uk>
Date: 1996/08/21
Message-ID: <DwHp1M.1Ay_at_cix.compulink.co.uk>#1/1
Date: 1996/08/21
Message-ID: <DwHp1M.1Ay_at_cix.compulink.co.uk>#1/1
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. Received on Wed Aug 21 1996 - 00:00:00 CEST