PL/SQL
From: Tari Chan <tchan_at_scscc1.scsnet.scs.com.sg>
Date: 1996/04/17
Message-ID: <3175907A.441D_at_scscc1.scsnet.scs.com.sg>#1/1
Date: 1996/04/17
Message-ID: <3175907A.441D_at_scscc1.scsnet.scs.com.sg>#1/1
Hiya!
We are developing this system using PL/SQL but we encounter some problem.
We did a benchmark and discovered that each SQL statement took about 0.03
second, and each record has to go through an average of about 100 SQL
statement. This poses a problem because we have an average of about 8000
records to process per run and this will take about 6.7 hours.
we wonder is there any way we can do to improve performance (not including getting a better server). Any suggestions/ideas are greatly appreciated. Please email me at tchan_at_scscc1.scsnet.scs.com.sg Thank you for reading and have a great day! Received on Wed Apr 17 1996 - 00:00:00 CEST