[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Messages to stdout in embedded mode?



M. A. Sridhar wrote:

> The query_logging parameter is not set in the configuration (it is commented
> out) and the debug_log_level is set to 30.
> 
> But more importantly, do you think that the reopening of connections can have
> any negative effects on performance? Or should I not worry about it?

Each time the database engine has to stop and start, there will be a 
delay of anywhere between 5 and 30 seconds.  Whether this is a problem 
or not, it really depends on your application.  If there is often a long 
time when there is no communication with the database then it may be a 
benefit to reclaim the resources associated with the database by 
allowing the database to shut down.  It is often desirable to keep the 
database connected in a long time running server application, however.

Toby.