6.0.0-beta6
▾
Tasks
New Task
Search
Photos
Wiki
▾
Tickets
New Ticket
Search
dev.horde.org
Toggle Alerts Log
Help
4/10/26
H
istory
A
ttachments
C
omment
W
atch
Download
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
N
ew Ticket
M
y Tickets
S
earch
Q
uery Builder
R
eports
Saved Queries
Open Bugs
Bugs waiting for Feedback
Open Bugs in Releases
Open Enhancements
Enhancements waiting for Feedback
Bugs with Patches
Enhancements with Patches
Release Showstoppers
Stalled Tickets
New Tickets
Horde 5 Showstoppers