Hi, i am developing the JSP/Servlet system now. Let we discuss database pooling, how you normally do that? My developing application is open/close database object every single class instance.
My design is every time, we need access database then we invoked a database class object, execute SQL and close it. It is logically consume much of the computing process in server.
But my friend suggest that open a database object like a global database connection pooling. This object will open when user login and close when user logout. I feel this consume much memory resource to handle large amount user.
Who's what's the weakness for either design? Your recommendation is much appreciate.