Tickets :: Comment on [#12656] Horde pings SQL server with each database query

* Your Email Address
* Spam protection	Enter the letters below: .__.. .._. __ .___ \| \|\|_/ \| / `[__ \|__\\| \_\|_\__.\|
Comment	> My first shot at trying to reduce the number of pings to the SQL database. > > Assume the connection to the database is good (which will generally > be the case) and send queries straight away. Only ping the SQL > database if an exception occurs (much less common). If the server > doesn't respond, reconnect and try again (up to three times). If does > respond to the ping, assume something else was wrong and throw > exception as usual. > > The logic might be improved by interpreting $e->getMessage(). If it > contains 'SQLSTATE[08', there is a definitly a connection problem and > we should reconnect. But I'm not sure if all supported SQL databases > support this status code, hence the (slightly less efficient) ping.
Attachment
Watch this ticket