October 15, 2009 at 6:21 pm
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
October 23, 2009 at 5:35 am
Here is a discussion about the same topic: http://www.ureader.com/msg/11511384.aspx
-------------------
StarWind Software developer ( http://www.starwindsoftware.com )
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply