|
|
Posted by d on 01/12/06 12:27
"Dikkie Dik" <nospam@nospam.org> wrote in message
news:dq3k3s$5io$1@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.
>>
Navigation:
[Reply to this message]
|