Hi Guys,
I am running a C#.Net app
I have two options
1. If i run a single query by opening a connection and running a query and then close the connection it is taking
3 seconds.
2. If i open the connection and keep it open and run all my queries using the same connection then the response
is instantaneous. ..less than 1 second.
I can go with option 2 which gives me the best response time but I need following answers:
(a) How many connections can i keep open in SQL Express
(b) What type of performance hit will i take by keeping multiple connections open - I need specific answers of hardware penalties(specifica lly speaking RAM) given that SQL Express utilizes only 1GB of RAM.
Appreciate your response
Thanks