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>


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.

The areas I have found useful so far are:

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

Original text of this message