SQLEXPRESS 2005 Open Connections

SQLServerCentral is supported by Red Gate Software Ltd.

Home Articles Editorials Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server Express » SQLEXPRESS 2005 Open Connections

SQLEXPRESS 2005 Open Connections

Rate Topic

Display Mode

Topic Options

Author

Message

SQL Kid-1137444

Posted Thursday, October 15, 2009 6:21 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, October 19, 2009 6:52 PM
Points: 3, Visits: 9

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

Post #803895

psvirin

Posted Friday, October 23, 2009 5:35 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, November 17, 2009 8:43 AM
Points: 32, Visits: 73

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

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

Post #807763

« Prev Topic | Next Topic »

Permissions