What to do get best performance by OleDbConnection object

Question

0.00/5 (No votes)

See more:

What performs best: (OleDbConnection)
1) A Closed Connection object assign to a global variable and Open it when need
Or
2) A Opened Connection object assign to a global variable and keep it throughout the application
Or
3) Everytime creates a new local Connection object and close it after use
Or
4) Anything other suggestion(s)

The main objectives: The best ferformance

Posted 19-Mar-11 18:36pm

jdebabrata

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Answer 1 · 2011-03-19T19:46:00

Solution 1

Every time creates a new local Connection object and close it after use.

This is a homework question. This was given to you to tell what is way to create the connection object such that there is no memory leakage. Thus, keeping it local and open when needed and close after use is the best way to make least memory issue because of open connection.

Posted 19-Mar-11 19:46pm

Sandeep Mewara

Comments

Albin Abel 21-Mar-11 1:54am

:) my 5

jdebabrata 22-Mar-11 9:05am

Sandeep Mewara
Thank you very much for your opinion.
What about "A Closed Connection object assign to a global variable and Open it when need and after use, just close it". I think, it also serves well.

jdebabrata

Sandeep Mewara 22-Mar-11 11:16am

It does but, it's scope is global and thus will be dangling for more time than a local one.

jdebabrata 22-Mar-11 11:38am

Yes, you'r absolutely right. Thank you very much.

Sandeep Mewara 22-Mar-11 12:13pm

Thanks! Kindly close the question now by accepting the answer.