[thelist] [ASP] slow server. What possible causes?

Nicole P nicole at parrot.ca
Tue Apr 30 07:17:01 CDT 2002

Thanks Dam for the links, but I couldnt find anything where performance
degrades over time.

And yes, Karen, I free everything that I set now, at least I think so. Some
may still be lurking though.
Would that create a performance degradation over a few hours?

The system reacts very well after a reboot, and starts slowing down after an
hour or so, and eventually reaches a point that it is unusable.

----- Original Message -----
From: "Daniel J. Cody" <djc at members.evolt.org>
> I'm no ASP expert, but have you checked out the articles on the
> evolt.org website about this issue?
> watch yee ole wrap.
> hth!
> .djc.
> Nicole P wrote:
> > Hello voltaires.
> >
> > I developped years ago a little intranet that gets into action only a
> > of times a year.  It's ASP-based, with an Access database (3 users at
> > most concurrently)
> >
> > The server that runs my intranet is up all the time, and behaves fine
> > rest of the year. However, when my pages are in action, the server slows
> > down to a crawl, and only a reboot can fix it. It degrades slowly over
> > course of a few hours, until it becomes unusable.
> >
> > I thought about checking memory leaks (at the time I wrote this
> > I wasn't systematically releasing all recordsets I was creating). So
now, I
> > have set rst = nothing wherever necessary (I may have missed a few,
> > ...) Would that be a cause for a server slowdown?
> >
> > What other possible causes should I look at?
> >
> > Other infos:
> > no other COM objects but those that come standard with IIS and Access
> > used (connection, command, and recordset objects) except for ASPMail in
> > of errors
> > I never return a huge number of rows. 20-40, at the max. The content of
> > those rows are not big (no huge Memo fields).

More information about the thelist mailing list