Performance Problem
From: David Mao <David.Mao_at_lambada.oit.unc.edu>
Date: 11 Nov 1994 16:53:53 -0600
Message-ID: <9411112254.AA06192_at_lambada.oit.unc.edu>
Date: 11 Nov 1994 16:53:53 -0600
Message-ID: <9411112254.AA06192_at_lambada.oit.unc.edu>
I have a real time data collection application. Receives Clock IN and Clock OUt Transactions for TIme and Attendance.
It is taking 2-3 minutes per transaction to insert a row into a table.
The program is written in C using Cursors that are held and not closed.
The program was built under 7.0.13... and runs on 7.0.15...
The TEMP tablespace is 52MB. It gets consumed. Temporary lock limit is reached. These happen 2-3 times a day.
Any reasons for this to happen? Received on Fri Nov 11 1994 - 23:53:53 CET