Click here to Skip to main content
15,909,466 members
Home / Discussions / Database
   

Database

 
AnswerRe: How to write IF Condition in Stored Procedure Pin
Not Active7-Oct-09 14:20
mentorNot Active7-Oct-09 14:20 
AnswerRe: How to write IF Condition in Stored Procedure Pin
J4amieC7-Oct-09 23:07
J4amieC7-Oct-09 23:07 
Question'Best practices' for managing data base connections Pin
Gary Wheeler7-Oct-09 8:29
Gary Wheeler7-Oct-09 8:29 
AnswerRe: 'Best practices' for managing data base connections [modified] Pin
Luc Pattyn7-Oct-09 8:37
sitebuilderLuc Pattyn7-Oct-09 8:37 
GeneralRe: 'Best practices' for managing data base connections Pin
Gary Wheeler7-Oct-09 8:44
Gary Wheeler7-Oct-09 8:44 
GeneralRe: 'Best practices' for managing data base connections Pin
Luc Pattyn7-Oct-09 8:49
sitebuilderLuc Pattyn7-Oct-09 8:49 
AnswerRe: 'Best practices' for managing data base connections Pin
εїзεїзεїз7-Oct-09 10:57
εїзεїзεїз7-Oct-09 10:57 
AnswerRe: 'Best practices' for managing data base connections Pin
David Skelly7-Oct-09 22:52
David Skelly7-Oct-09 22:52 
You could consider some sort of connection pooling strategy. Open-use-close is not very efficient when you are accessing the database very frequently. It is more efficient to pool and reuse open connections in this circumstance. One technique that connection pooling libraries use is to test the connection before returning it from the pool. Then if the connection is bad (e.g. timed out by the database) you can throw it away and open a new one. That way, if your application is making lots of database accesses you avoid the overhead of opening and closing connections all the time. When your application idles and does not access the database for a long time, the connection can be dropped and a new one will be opened, "invisibly" from the point of view of the code using the connection.

You don't say what language of framework your application uses, but there are connection pooling libraries available for .NET, Java, Python, Ruby and many others.
GeneralRe: 'Best practices' for managing data base connections Pin
Gary Wheeler8-Oct-09 0:33
Gary Wheeler8-Oct-09 0:33 
AnswerRe: 'Best practices' for managing data base connections Pin
PIEBALDconsult12-Oct-09 6:44
mvePIEBALDconsult12-Oct-09 6:44 
QuestionProblem with LOB Locators. Pin
Code-o-mat7-Oct-09 6:37
Code-o-mat7-Oct-09 6:37 
QuestionFIle Format Problems Pin
Vimalsoft(Pty) Ltd7-Oct-09 4:54
professionalVimalsoft(Pty) Ltd7-Oct-09 4:54 
AnswerRe: FIle Format Problems Pin
dan!sh 7-Oct-09 5:15
professional dan!sh 7-Oct-09 5:15 
GeneralRe: FIle Format Problems Pin
Vimalsoft(Pty) Ltd7-Oct-09 5:23
professionalVimalsoft(Pty) Ltd7-Oct-09 5:23 
GeneralRe: FIle Format Problems Pin
dan!sh 7-Oct-09 6:03
professional dan!sh 7-Oct-09 6:03 
GeneralRe: FIle Format Problems Pin
Vimalsoft(Pty) Ltd7-Oct-09 6:19
professionalVimalsoft(Pty) Ltd7-Oct-09 6:19 
GeneralRe: FIle Format Problems Pin
Ashfield8-Oct-09 1:29
Ashfield8-Oct-09 1:29 
GeneralRe: FIle Format Problems Pin
Vimalsoft(Pty) Ltd8-Oct-09 1:31
professionalVimalsoft(Pty) Ltd8-Oct-09 1:31 
GeneralRe: FIle Format Problems Pin
Ashfield8-Oct-09 3:39
Ashfield8-Oct-09 3:39 
GeneralRe: FIle Format Problems Pin
Vimalsoft(Pty) Ltd8-Oct-09 4:00
professionalVimalsoft(Pty) Ltd8-Oct-09 4:00 
GeneralRe: FIle Format Problems Pin
Ashfield8-Oct-09 8:38
Ashfield8-Oct-09 8:38 
GeneralRe: FIle Format Problems Pin
Vimalsoft(Pty) Ltd8-Oct-09 20:20
professionalVimalsoft(Pty) Ltd8-Oct-09 20:20 
QuestionSQL Query Problem Pin
Syed Shahid Hussain7-Oct-09 4:29
Syed Shahid Hussain7-Oct-09 4:29 
AnswerRe: SQL Query Problem Pin
dan!sh 7-Oct-09 4:53
professional dan!sh 7-Oct-09 4:53 
GeneralRe: SQL Query Problem Pin
Syed Shahid Hussain7-Oct-09 5:30
Syed Shahid Hussain7-Oct-09 5:30 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.