Hi, for some reason the sfs is making an excesive amount of calls to the db for the test sql.
I also saw this post http://www.smartfoxserver.com/forums/viewtopic.php?t=16226.
The pool has a limit of 25 connections but it is permitted to grow if there is a need.
What I see in the db is a lot of the test sql in idle state and a few others that are actually genuine calls from the game.
Why is that.
I'm using postgresql and the version 2.13.0 of sfs.
Too much test sql by sfs
-
- Posts: 38
- Joined: 07 Nov 2016, 12:26
Re: Too much test sql by sfs
Hi,
the test SQL is used to check that a connection in the pool is still valid. What you see is normal, as every connection has to be tested and the pool keeps connections alive in order to reuse them quickly, instead of creating and destroying them every time, which it too expensive.
Cheers
the test SQL is used to check that a connection in the pool is still valid. What you see is normal, as every connection has to be tested and the pool keeps connections alive in order to reuse them quickly, instead of creating and destroying them every time, which it too expensive.
Cheers
Who is online
Users browsing this forum: No registered users and 96 guests