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

[Nicole P]

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?
>
http://evolt.org/search/index.html?keywords=asp+performance&option=all&tid=0
&maxrows=10&status=1
>
> watch yee ole wrap.
>
> hth!
>
> .djc.
>
> Nicole P wrote:
> > Hello voltaires.
> >
> > I developped years ago a little intranet that gets into action only a
couple
> > of times a year.  It's ASP-based, with an Access database (3 users at
the
> > most concurrently)
> >
> > The server that runs my intranet is up all the time, and behaves fine
the
> > 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
the
> > course of a few hours, until it becomes unusable.
> >
> > I thought about checking memory leaks (at the time I wrote this
application,
> > 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,
still
> > ...) 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
are
> > used (connection, command, and recordset objects) except for ASPMail in
case
> > 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).