Hi Jojy,
IMO, It is good to have the connection open only when the DB access is required and close that once you are done with DB operations. If there is a sequence of opetations to be done with the database within a procedure/function, then it might be good that open the connection once the control enters the procedure and close that before the control exits from there. So far I have been sticking to this way of approach. But should be careful in closing connection then and there after use.
When Application/Session level db connection are used, then the connection per user is open till the time user quits the site, even when the user is roaming around the static pages.
May be you would get good inputs from others in this forum too.
Hope that helps.
Cheers!
_________________________
- Vijay G
Strive for Perfection
|
Best way to connect to the data base Is it Appl...
What is the best way of connecting to a database? Is it creating an application level variable which is shared by all users ? Or is it a session level variable for each session ? Or is it a connection in each procedure ? Or Should it be like opening the connection when the database is accessed and closing it immediately which means multiple opening and closing in the same procedure. 