Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Data Access with Access 2002 DB is SLOW
0 views
Skip to first unread message
Kevin Adler
Sep 12, 2002, 1:57:23 PM9/12/02
to
I have multiple websites running on a simple access DB
like a catalog system of products. Just moved from a
server that ran fine to a new (faster, better) server and
now access seems to be very slow under large loads.
like a catalog system of products. Just moved from a
server that ran fine to a new (faster, better) server and
now access seems to be very slow under large loads.
Both servers ran IIS 5, w2k, first server had SP2, new
server SP3. Is there a setting i missed that is causing
access to slow down?
At times it takes 2 minutes to make a single DB call and
display the information. After some time the system will
response super quick again.
I searched MS Support but did not find anything new that
would cause this. The CPU and Memory useage are both low,
and I know the code / db is fine as it was very fast on
the old server!
Any help would be greatly appreciated!
Thank You
Kevin Adler
ke...@ask4csi.com
JR
Sep 13, 2002, 10:31:36 PM9/13/02
to
Even though you didn't mention it, I suppose you're utilizing .asp pages to
work with that Access db.
If so, try enabling "connection pool" for the mdb driver (ODBC).
work with that Access db.
If so, try enabling "connection pool" for the mdb driver (ODBC).
JR
-----------------------------------------
"Kevin Adler" <ke...@ask4csi.com> escreveu na mensagem
news:163f601c25a85$d8ece830$39ef2ecf@TKMSFTNGXA08...
0 new messages