It's not clear whether or not you have turned on all levels of logging in
the CP and RDBMS services and looked at the log. If not, you should, as it
would probably tell you something.
-- Curt Springer, Team ND
At 03:25 PM 7/2/99 -0500, Hoskins, John D. wrote:
>Hi,
>NT4sp4, Oracle8, ND4.13, IIS3
>
>I am having a bit of a performance problem, and would like to see if anyone
>has any ideas.
>I've got a situation where the application is inserting around 100 rows at a
>time, and it is taking upwards of 45 seconds. The biggest culprits are the
>inserts, which are taking up to 30 seconds themselves. My code looks like
>this:
>...
>CSpTransaction insertTrans = new CSpTransaction();
>
>int numOfRows = _questionIndex.size();
>for (int i=numOfRows-1; i>=0; i--) {
> _insertObject.clearAllValues();
> _insertObject.setValue(0,_surveyID);
> _insertObject.setValue(1,_sectionId.get(i));
> _insertObject.setValue(2,_questionId.get(i));
> _insertObject.setValue(3,_surveyGroupID);
> _insertObject.setValue(4,_respondentID);
> _insertObject.setValue(5,today);
> _insertObject.setValue(6,_response.get(i));
> _insertObject.setValue(7,_questionSubOrder.get(i));
> _insertObject.setValue(8,insertSequence);
> _insertObject.setValue(9,_questionOrder.get(i));
>
> insertTrans.addDataObject(_insertObject);
>}
>insertTrans.execute();
>if (!insertTrans.succeeded()) {
> returnValue = false;
>}
>...
>
>And it is the insertTrans.execute() which takes the 30 seconds to run (I
>figured this out with timestamps in the code).
>Any thoughts on why this might be so slow?
>
>> John Hoskins
>> TDS Computing Services
>> Internet Technology Team
>> [EMAIL PROTECTED]
>> 608.664.8263
>> 608.664.8288 (fax)
>>
>_________________________________________________________________________
>
>For help in using, subscribing, and unsubscribing to the discussion
>forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
>
>For dire need help, email: [EMAIL PROTECTED]
>
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
