[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.