We're currently ASP (no COM, VBScript classes only) and SQL Server.
We're currently in the design phases for moving to .NET. In doing so, we did some performance comparisons, and I thought you guys might be interested, considering web services were slower then ASP.OLD, when put under a load.
1 = .NET
Code behind doing requests through a business object, business object using a data layer (all ADO.NET SQLDataReader).
2 = .NET using a Web Service
Code behind doing requests through a web service.
3 = ASP.OLD
ASP page instanting a VBScript class, calling to the database.
(All three architectures use stored procedures)
Threads Clients CPU% Req/Sec
1 2 5 20 22
5 5 50 46
10 5 80 79
25 5 100 95
2 2 5 30 17
5 5 70 36
10 5 90 43
25 5 100* 25
3 2 5 65 26
5 5 95 37
10 5 100** 34
25 5 100* 31
* = Server pegged. Totally unresponsive. Dead by all practical explanations.
** = Not totally dead, but bobbing along at 90-100% utilization.
Conclusion: Web services baddddddddd.
Anyways, enjoy!
-Jason