I am debugging some performance issues in my app (DB2 datasource), I was surprised to find that:
1) it is executing an insert command for each row instead of a single INSERT statement
2) why the SELECT after each INSERT?
Is this right, doesn't look right to me. This is a single SAVE() call against my BO after ADD()ing records in a looping structure.
Thanks for taking a look... debug info below, a pair of these exists for each row added.
Command #: 171
Timestamp: 2007-12-07 16:14:23.606
General Command Settings
Command Type: Text
Object Type: DDTek.DB2.DB2Command
Connection String: XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Transaction: False
Command Settings
CommandText: INSERT INTO "SIGMA"."EDI_MILNDX" ("MIL_CODEID", "MIL_NAME", "MIL_NUM", "MIL_RV") VALUES (?, ?, ?, ?)
Command Parameters
P0: 'SHWX' [DbType: String | Size: 4 | Direction: Input | SourceColumn: MIL_CODEID | SourceVersion: Current]
P1: 'Shaw Industries' [DbType: String | Size: 15 | Direction: Input | SourceColumn: MIL_NAME | SourceVersion: Current]
P2: '0' [DbType: Decimal | Size: 0 | Direction: Input | SourceColumn: MIL_NUM | SourceVersion: Current]
P3: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: MIL_RV | SourceVersion: Current]
Command #: 172
Timestamp: 2007-12-07 16:14:23.668
General Command Settings
Command Type: Text
Object Type: DDTek.DB2.DB2Command
Connection String: XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Transaction: False
Command Settings
CommandText: SELECT "MIL_PK", "MIL_RV" FROM "SIGMA"."EDI_MILNDX" WHERE MIL_PK = IDENTITY_VAL_LOCAL()
Command Parameters
N/A No parameters are defined
Keith Chisarik