Hi Brian,

Thanks for the inputs.

This is a project where the client already has the SPs and we are just creating a wrapper on top of the SP...

Hi Lutz, Brian,

Thanks a lot for the replies.

For each product, the analysis is done by querying various tables - about 5 tables to find out the inventory, incoming supplier ...

Hi,

I am using Asp.net webservice to invoke the connections. In this case does .Net provide connection pooling. I thought the db creates and manages the connection pool.

We are creating...

Hi Brian,

I am facing a similar problem in my project - I don't see the issue in development, but when we move to production the...