We have 26k accounts in our Combu3 system, and as it's grown to that number, it's gotten slower and slower to respond, mainly when loading the admin console in a browser, but I think some players are also getting timeouts. Any idea why or what we can do? (We have 180k accounts on the Combu2 system on an older game, both on same server, and haven't had any problems like this.) I also noticed when loading the Session Tokens page that we have 777656 entries for them. Is that excessive?
thanks
Dave
That number of records could be huge, you can try to clean it and retry: go to the page of Session Tokens and delete the very old ones by selecting a date and then clicking Delete, it will delete all session tokens up to that date, so you could for example select a date older than 1-2 weeks (make a backup of the database before doing this).
FRANCESCO CROCETTI @ SKARED CREATIONS
Okay, will do!
Hmm, in looking at the CB3_SessionToken table, there are 405,396 records where the IdAccount field is 0. Does this mean those are sessions that are tied to an unknown user, or what?
Hmm, in looking at the CB3_SessionToken table, there are 405,396 records where the IdAccount field is 0. Does this mean those are sessions that are tied to an unknown user, or what?
Until a client doesn't make a login it remains "anonymous" so IdAccount is 0, but the session starts immediately because there's the double security encryption and the runtime generated encryption key is stored for the connected client. It should mean that many sessions were closed before an authentication, that is the users quit the client without authenticating.
FRANCESCO CROCETTI @ SKARED CREATIONS
okay, thanks! Also, can we change the session timeout? It's way too long (over a month).
