General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2000 Server
Thanks.
This system is made of a VFP COM object serving about 40 sites in a web farm (4 webservers + file sever). Busy sites may get about 30-40 simultaneos users.
All the requests are made via an ASP template that based on the request type it is serving back the HTML to be displayed. So the results and HTML are built in the COM object. The HTML templates are included now in the project (see my previous post) - however some HTML templates specific to some sites stil reside on the file server.
The database query is pretty fast and the performance was ok until recently when we noticed a lot of application pool recycles due to unresponsive sites.
It looks like we hit a limitation onthe number of requests the system can handle.
At the moment I am trying to optimize this and also test with SQl Server.
One possible problem: I am passing the request object for each call. Does this imapct the performance. I do need the request object to extract data passed in the form. Is theer anoher way of doing this?
regarding the volume of the data: not a lot of data.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only