InstantForum.NET v4.1.4SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 18 Mar 2010 23:42:05 GMT20http://www.sqlservercentral.com/Forums/Topic803895-324-1.aspxHere is a discussion about the same topic: [url=http://www.ureader.com/msg/11511384.aspx]http://www.ureader.com/msg/11511384.aspx[/url]-------------------StarWind Software developer ( [url=http://www.starwindsoftware.com]http://www.starwindsoftware.com[/url] )Fri, 23 Oct 2009 05:35:30 GMTpsvirinhttp://www.sqlservercentral.com/Forums/Topic803895-324-1.aspxHi Guys,I am running a C#.Net appI have two options1. 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 responseThanksThu, 15 Oct 2009 18:21:39 GMTSQL Kid-1137444