Too much test sql by sfs

Post here your questions about SFS2X. Here we discuss all server-side matters. For client API questions see the dedicated forums.

Moderators: Lapo, Bax

votagusvotag
Posts: 38
Joined: 07 Nov 2016, 12:26

Too much test sql by sfs

Postby votagusvotag » 25 Jan 2018, 17:51

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.
User avatar
Lapo
Site Admin
Posts: 23008
Joined: 21 Mar 2005, 09:50
Location: Italy

Re: Too much test sql by sfs

Postby Lapo » 26 Jan 2018, 08:28

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
Lapo
--
gotoAndPlay()
...addicted to flash games

Return to “SFS2X Questions”

Who is online

Users browsing this forum: Baidu [Spider] and 68 guests