[MySQL] Question...
#5

Quote:
Originally Posted by Sinner
Посмотреть сообщение
Even if these users don't visit they can be used for statistical calculations or other things later on. MySQL has absolutely no issue with some extra rows and your queries won't be any slower too. So, no. There's really no reason to.
Actually yes it will be slower. Many users just come ingame, register and never come again (like 30%+ of the accs).

You should set a field "laston", make it a unix timestamp. When a player connects, set this field to the current timestamp.

Then, when deleting users, if the current gettime() - their laston is larger than 31556926 (1 year), delete their user account. If a user does not login once a year, he probably doesn't care about the game that much.
Reply


Messages In This Thread
[MySQL] Question... - by aLTeR - 24.08.2013, 11:53
Re: [MySQL] Question... - by Misiur - 24.08.2013, 13:39
Re: [MySQL] Question... - by Sinner - 24.08.2013, 14:24
Re: [MySQL] Question... - by aLTeR - 24.08.2013, 14:28
Re: [MySQL] Question... - by Mean - 24.08.2013, 14:51

Forum Jump:


Users browsing this thread: 1 Guest(s)