By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,245 Members | 1,797 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,245 IT Pros & Developers. It's quick & easy.

Is it better to open connection with DB at beginning and close at end, or after every "object run"?

P: n/a
Sorry for the English.
I mean, when building my applications, I often need to do several
database actions, and I'm thinking, what's better?

1) Open connection with DB, for instance mySQL, at beginning and close
at the end, so every "unit" in the code knows that THIS IS the
connection, and its opened.

OR

2) Every "unit" in the code opens and closes DB connection
independantly.

Jan 11 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
3) The database object/connection is created as soon as it is needed and
passed to all units that need it. This allows reuse of the units.

Best regards

Rafi B. wrote:
Sorry for the English.
I mean, when building my applications, I often need to do several
database actions, and I'm thinking, what's better?

1) Open connection with DB, for instance mySQL, at beginning and close
at the end, so every "unit" in the code knows that THIS IS the
connection, and its opened.

OR

2) Every "unit" in the code opens and closes DB connection
independantly.

Jan 11 '06 #2

P: n/a
d
"Dikkie Dik" <no****@nospam.org> wrote in message
news:dq**********@news.cistron.nl...
3) The database object/connection is created as soon as it is needed and
passed to all units that need it. This allows reuse of the units.
Ideally, it should use persistent connections (if the server allows), and
the object shouldn't initiate its connection to the DB unless it's passed a
query (so don't do it when the object is constructed, but when it's actually
used).

Best regards

Rafi B. wrote:
Sorry for the English.
I mean, when building my applications, I often need to do several
database actions, and I'm thinking, what's better?

1) Open connection with DB, for instance mySQL, at beginning and close
at the end, so every "unit" in the code knows that THIS IS the
connection, and its opened.

OR

2) Every "unit" in the code opens and closes DB connection
independantly.

Jan 12 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.