[ND] Inserting 100 rows takes 30-40 seconds.

[Hoskins, John D.]

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]