ACCESS Preformance seems to degrade over time

Results 1 to 2 of 2

Thread: ACCESS Preformance seems to degrade over time

  1. #1
    Michael Esposito Guest

    Default ACCESS Preformance seems to degrade over time

    I have a large ASP web-site that uses DSNless connections to three large databases. I always close my database and record sets after use (expect in the case of paging a record set where I relay on IIS&#039s garbage collection to do the job.) Even so the latter cases do not play a big roll in the site. <BR><BR>I am beggining to suspect that something about the way I am using the databases is causing the site to get slower and slower over time. When my ISP reboots the server things get better. However starting and stopping the web-server does not.<BR><BR>Any Ideas. <BR><BR>(P.S I know I can increase preformance going to DSN connections, which I plan on doing, but that still doesn&#039t explain the slow degradation of preformance. )<BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969
    Posts
    2,849

    Default RE: ACCESS Preformance seems to degrade over time

    DSNless connections are faster than DSN Connections, especially if there are in the neighborhood of 20 concurrent users.<BR><BR>One thing I suggest you do, which might not be feasible, is upgrade to SQL Server as opposed to using Access.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •