Admin,
I am using ASP runner Pro with ODBC DSN connection to access a MS SQL DB.
When comparing the cpu usage between using a linked table in an MS Access database and in other case using the ASP ODBC DSN connect there seems to be 100% usage on the server machine for 5 to 10 seconds. The cpu usage when linking with MS Access is very low (near to 20%).
I just tried a SELECT TOP 5000 but this doesn't have any effect. Suggest the difference is the recordset cache used by MS Access vs. ODBC DSN over IIS.
Is it possible to decrease the cpu usage by configuring the DSN connect string for telling the ASP application to use only a defined range of records when opening the SQL request?
