Long Wait Time Access Small Access Database through ODBC 
Author Message
 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



Fri, 24 Aug 2001 03:00:00 GMT
 Long Wait Time Access Small Access Database through ODBC

Stop the ODBC Trace if it is on.
Quote:

> 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



Mon, 19 Nov 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Small backup takes long time to restore on larger database

2. Help - Long waits with ADO and Access over a network

3. ODBC database crashing accessing progam going for an access database

4. Pagelatch_ex long wait time

5. Long time waiting for connection

6. Long time waiting for connection

7. MySQL ODBC - Coverting Access date/time type to MySQL date/time type

8. Response Time Problem using Oracle ODBC links to Access Database

9. Slow Response Time using ODBC to access an Informix database

10. Small table taking long time to update

11. Sqlserver small table taking long time to update

12. Problem accessing Access 97 replicated database with ODBC 4.02


 
Powered by phpBB® Forum Software