db connection open
[215 byte] By [padikkathavana] at [2007-11-27 6:47:50] 
Hi,normally we keep the database open always. why ?why we are not opening the db whenever we want to insert the data or retrieve the data from the db?what is the basic reason behind this?
# 1
performancetschodta at 2007-7-12 18:20:54 >
# 2
thankscan you pls. explain a little bit further?...padikkathavana at 2007-7-12 18:20:54 >
# 3
> thanks> > can you pls. explain a little bit further?...You asked why. Performance.What specifically did you not understand about that answer?cotton.ma at 2007-7-12 18:20:54 >
# 4
Sorry. don't mistake.I am new to java.what I mean is, how performance is increased by the keeping the db open always ?thanks...padikkathavana at 2007-7-12 18:20:54 >
# 5
> Sorry. don't mistake.
>
> I am new to java.
>
> what I mean is, how performance is increased by the
> keeping the db open always ?
>
> thanks...
Ah. How.
Well there is a certain amount of overhead associated with creating and destroying the sockets that often underlie database connections. There is also some overhead to do with steps like user authentication from the database side of things.
All of this overhead is a non-issue when you re-use connections through a connection pool.
cotton.ma at 2007-7-12 18:20:54 >
Database Connectivity Hot Topic
- Help me out with java jeap,saveabend and singal 11 error!
- If Oracle DB Connection goes down,it should reconnect the DB again
- resultset error
- Database location in Applet
- database connectivey
- how to get DB server current time?
- sql forum or help with sql query
- Does Hibernate supports multiple schemas connection ?
- Query regarding the Class.forname method
- problem with executeQuery statement
- Creating Stored Procedure in Java
- MYSQL connector
Database Connectivity
All Classified
- Archived Forums
- Enterprise & Remote Computing
- Java Essentials
- Desktop
- Core
- Solaris Operating System
- Security
- Database Connectivity
- Java Mobility Forums
- Web & Directory Servers
- Development Tools
- Application & Integration Servers
- Java HotSpot Virtual Machine
- Other Topics
- E-Mail, Calendar, & Collaboration
- Developer Tools
- General
- Administration Tools
- Sun Hardware
- Storage Forums
- Java Enterprise System
- StarOffice
- Open Source Technologies
- BigAdmin
- Real-Time
- Java Coding