
Long Wait Time Access Small Access Database through ODBC
Server Hardware Setup
---------------------------------
Winnt SP 4
Proxy 2 Latest Hotfix
Access Components SP2
256 Ram
Dual PII 450
IDE Drive (Don't ask, don't laugh)
ODBC Information
--------------------------
Access ODBC Resource
Local Database
The Problem:
On one system similar config less proxy server the database access is
extremely fast (less then 1 second). On the server with proxy accessing the
ODBC Resource which is a very small access database < 190K and 23 Records -
The hardrive spins for nearly 10 seconds before delivering the content to my
clients web browser. I have been through the log files for proxy and IIS as
well as the event viewer, but nothing is pointing to a problem.
The HTML utilized to extract information from the database is both
ASP/IDC/HTX (Tried everything to speed up access times)
Any suggestions would be appreciated.
SBroad