update through ODBC

From: __ <2_at_2.com>
Date: Fri, 25 Jan 2002 08:39:09 -0500
Message-ID: <a2rloq$q8p16@kcweb01.netnews.att.com>

Dear All,

I am trying to tune an update of a single table by a third party software that uses ODBC to update 6000 rows. These 6000 rows take about 7 minutes to update. The ODBC trace shows the following output. I am trying to understand if the third party software is seding in row-by-row, or if all rows are sent in simultaneously. To test this I updated only 9 rows from the thirdparty software and I got one "UPDATE" statement and nine "SQLEXECUTE" statements in the log. Am I write in assuming that the software is sending in 9 different update statements?

Any help will be greatly appreciated.

svcar32         690-734 EXIT  SQLPrepare  with return code 0 (SQL_SUCCESS)
  HSTMT               007D26E8
  UCHAR *             0x0012F394 [      -3] "UPDATE abc1001 SET amount=?

WHERE curncy=? AND nature=? AND accnt=? AND flow=? AND period=? AND enumber=? AND partner=? AND ctshare=? AND region=? AND prod=? AND cmt=? AND supcat=? AND transf=? AND assign=? AND lnkacct=?\ 0"

  SDWORD                    -3

svcar32         690-734 ENTER SQLExecute
  HSTMT               007D26E8

svcar32         690-734 EXIT  SQLExecute  with return code 0 (SQL_SUCCESS)
  HSTMT               007D26E8

svcar32         690-734 ENTER SQLExecute
  HSTMT               007D26E8

svcar32         690-734 EXIT  SQLExecute  with return code 0 (SQL_SUCCESS)
  HSTMT               007D26E8

svcar32         690-734 ENTER SQLExecute
  HSTMT               007D26E8

svcar32         690-734 EXIT  SQLExecute  with return code 0 (SQL_SUCCESS)
  HSTMT               007D26E8

svcar32         690-734 ENTER SQLExecute
  HSTMT               007D26E8

svcar32         690-734 EXIT  SQLExecute  with return code 0 (SQL_SUCCESS)
  HSTMT               007D26E8

svcar32         690-734 ENTER SQLExecute
  HSTMT               007D26E8

svcar32         690-734 EXIT  SQLExecute  with return code 0 (SQL_SUCCESS)
  HSTMT               007D26E8

svcar32         690-734 ENTER SQLExecute
  HSTMT               007D26E8

svcar32         690-734 EXIT  SQLExecute  with return code 0 (SQL_SUCCESS)
  HSTMT               007D26E8

svcar32         690-734 ENTER SQLExecute
  HSTMT               007D26E8

svcar32         690-734 EXIT  SQLExecute  with return code 0 (SQL_SUCCESS)
  HSTMT               007D26E8

svcar32         690-734 ENTER SQLExecute
  HSTMT               007D26E8

svcar32         690-734 EXIT  SQLExecute  with return code 0 (SQL_SUCCESS)
  HSTMT               007D26E8

svcar32         690-734 ENTER SQLExecute
  HSTMT               007D26E8

svcar32         690-734 EXIT  SQLExecute  with return code 0 (SQL_SUCCESS)
  HSTMT               007D26E8

svcar32         690-734 ENTER SQLTransact
  HENV                007D1250
  HDBC                007D12F8
  UWORD                        0 <SQL_COMMIT>

svcar32         690-734 EXIT  SQLTransact  with return code 0 (SQL_SUCCESS)
  HENV                007D1250
  HDBC                007D12F8
  UWORD                        0 <SQL_COMMIT>

svcar32         690-734 ENTER SQLSetConnectOption
  HDBC                007D12F8
  UWORD                      102 <SQL_AUTOCOMMIT>
  SQLLEN                     1

svcar32         690-734 EXIT  SQLSetConnectOption  with return code 0
(SQL_SUCCESS)
  HDBC                007D12F8
  UWORD                      102 <SQL_AUTOCOMMIT>
  SQLLEN                     1

svcar32         690-734 ENTER SQLFreeStmt
  HSTMT               007D26E8
  UWORD                        1 <SQL_DROP>

svcar32         690-734 EXIT  SQLFreeStmt  with return code 0 (SQL_SUCCESS)
  HSTMT               007D26E8
  UWORD                        1 <SQL_DROP>

Received on Fri Jan 25 2002 - 07:39:09 CST