Response inserted below

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

Since ASP is not handling the data, go with ODBC. You'll get back a cursor, so it will be easier to deal with in the VFP code.

>
>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?

I'm not a web guy, so I have no idea.

>
>regarding the volume of the data: not a lot of data.