Pro*C performance tips?
From: Nigel Harwood <nigel_at_cnw01.storesys.coles.oz.au>
Date: 28 Jan 92 10:12:43 GMT
Message-ID: <1992Jan28.101243.19430_at_cnw01.storesys.coles.oz.au>
set REBIND=NO at the PCC level
Date: 28 Jan 92 10:12:43 GMT
Message-ID: <1992Jan28.101243.19430_at_cnw01.storesys.coles.oz.au>
I am 95% of the way through my first major Pro*C programming effort and am trying to extract any last bits of performance from Oracle. The program in question selects from table A, based on the information from table A does insert/update/delete to table B, does an insert to table C.
This has dropped me from 0.34 secs/trans to 0.14 secs/trans.
My next thought is to insert into table C from a 100 element array but I'm not all that keen as if I get a failure I will lose up to 100 rows of information.
Can anyone suggest any other areas to look at?
Regards
-- <<<<<<<<<<<<<<<<<<<<<<<<< Nigel Harwood >>>>>>>>>>>>>>>>>>>>>>>>>>> << Post: Coles Supermarkets, PO Box 480 Glen Iris 3146, Australia >> << Phone: +61 3 829 6090 E-mail: nigel_at_cnw01.storesys.coles.oz.au >> << FAX: +61 3 829 6886 >>Received on Tue Jan 28 1992 - 11:12:43 CET