by We have an executable parsing data and sending it off to the
MS SQL server.
We're finding the call SQLConnect() takes the significant amount of
the overall run time. The function call itself takes from about 1-2
seconds. The remaining SQL calls are quite fast.
The odbc.ini file is optimized so it will lookup section names faster,
which gave a boost to SQLConnect. ().
We've tried using shared memory from a Win32 .dll, though the
SQLAllocStmt complains the hdbc handle is invalid. We're debugging
this now.
Are there any other strategies to improve the conect performance?
Thanks.
Jim