Re: Database server auto-close
Chung Leong wrote:
As a side note: Don't wait till the end of the page before you close
the database connection. That's a recipe for "Too many connections"
errors. Read the necessary data from the database then close the
connection before you output to the client.
Could you expand on that?
I can't think of a way that closing at the end would do that.
.
Relevant Pages
- Re: Making a database connection global
... connection would be opened the same amount of time (which no-one yas yet ... Anyway, if he don't want to listen, a different angle will probably not ... to reference the database connection once. ... I created a class with a static database connection and the class opens ...
(microsoft.public.dotnet.framework.aspnet) - Database Connection Question
... we were using an asp include file with database functions ... and would open and close the database connection multiple times in 1 script. ... I don't know, the persistent connection seems much better to me, easier to ...
(microsoft.public.inetserver.asp.db) - Re: garbage collection
... it will get a reader back.. ... you can not reuse the connection on which it opened. ... > garbage collection issue, its a logical error. ... > on database connection is, ...
(microsoft.public.dotnet.framework.aspnet) - Re: Database Connection question
... the other is a standalone app and is using ... >java.sql.DriverManager for Connection. ... Every time after obtaining a ... >My task is to write generic code for database connection to be used in both ...
(comp.lang.java.programmer) - Re: simplifying repeating database connections in a class?
... I wrote my first PHP class today. ... >> repeat the database connection lines, ... That's why I'm calling the include twice, once in each function, ...
(comp.lang.php) |
|
