ASPDB Classic performance problems

[yodamon]

I have receintly installed aspdb classic and having performance problems after several hours that requires to shut down aspdb transaction package or reboot the server. Is there anyone else having this problem? Any solutions?

Name: ASPDB2002-EP-NT4-1231.dll
version: 2003.1.0.1

[Frank]

The problem could be any or a combination of the following and these are all classic ASP problems (not ASP-db) -

* You are having too many users writing to Access or non-SQL class DB (>5-10).

* You have just too-many users at one time.

* You are mixing your code with ASP-db code and have some leaks.

* Finally - Just simple - ASP is ASP. You can only go so far with it. That is why we are pushing "Tornado". The server is up since Feb 2002 and has not gone down once because of performance or system crash. This is the best-kept secret of DotNet that we discovered.

Throughout the development of the ASP, we have spent a lot of effort in tracking down performance killers and we are pretty confident that it is solid. Note that we did not performance these tests ourselves. We have customers that get with Microsoft to stress test ASP-db and we pass with flying color. If you experience bad crashes then you just have to separate them one module at a time and locate the killer. If you need our help, let us know.


FK