When looking at my MS SQL 2005 server that openfire uses, I have noticed that it incessantly pings the server with “Select 1”. In 5 mins, I have had this run 1464 times. I am gessing I can disable this by changing testBeforeUse and testAfterUse in openfire.xml to false. I want to know:
Why does openfire do this test before and after ever SQL requests?
Is there an adverse affect in turning this off?