ASP/COM scalability

[DavidJA]

Hey All,

I have a n-teir application which consits of an ASP front end hosted on IIS5, VB created DLL files hosted on COM+ (as server application) and SQL server database.

The application appears to work well, exept when a call to my com components takes more then a split second to execute.

EG, if userone calls myBusinessObject.myMethod, and myMethod takes a few seconds to execute (because it's a long running query) then that web site is effectivly disabled! Ie, no other users can make any requests to the web site, the requests appear to just sit there until myMethod is finished!

Why is that? The box is a Quad Xeon Proliant with a gig of ram, and cpu usage does not above 20%. (note the question is NOT why myMethod takes so long, but why no one else can access the web site whilst myMethod is executing.)

All feedback appriciated!

 

[codestorm]

Are the COM objects in question compiled as apartment threaded? codestorm
Fire bad. Tree pretty. - Buffy
select * from population where talent > 'average'
You're not a complete programmer unless you know how to guess.
I hope I never consider myself an 'expert'.
<insert witticism here>

 

[DavidJA]

Project Properties:
Threading Model: Apartment
Unattended Execution = true
Upgrade ActiveX control = true
Retained In Memory = true

 

[Palooka]

Could it be that you only have one database connection available at a time? If so, try setting up connection pooling. (A Google search on the term will point you to several explaining sites, if you don't know how.)

Palooka