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

[Daniel J. Cody]

Hey Nicole -

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).