SQLConnect() performance

SQLConnect() performance

Post by Jim Ki » Fri, 21 Jun 1996 04:00:00

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?




1. ODBC SQLConnect problem


I am having a problem with Microsoft's ODBC driver for Windows NT.
SQLConnect works fine until I try to debug my application with developer
studio.  While debugging, SQLConnect causes a general protection fault.  I
can't debug my application!!!  I don't know whether this is a bug in
SQLConnect or if I'm just using it incorrectly.

Any help would be appreciated


2. Cannot generate SSPI Context - reg key won't fix

3. Correct SQLConnect-Funktion ????

4. SQL Server 7.0 Restore Problem

5. SQLConnect error codes

6. MDX Question - Calculated Measure

7. SQLConnect fails, IM006

8. Script and Copy from one field to another field (Same database, different layout)

9. SQLConnect Using NT Authentication on SQL Server

10. SQLConnect question

11. VFP sqlconnect() works, sqltables() will not

12. SQLConnect ...

13. Help with multi-threaded SQLConnect calls