SQLEXPRESS 2005 Open Connections

• SQL Kid-1137444

  SSC Journeyman

  Points: 89

  More actions

  October 15, 2009 at 6:21 pm

  #212387

  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

• psvirin

  Mr or Mrs. 500

  Points: 542

  More actions

  October 23, 2009 at 5:35 am

  #1069921

  Here is a discussion about the same topic: http://www.ureader.com/msg/11511384.aspx

  -------------------

  StarWind Software developer ( http://www.starwindsoftware.com )