Mysql save wrong variables - mixing pSpawn and pSkin
#25

Quote:
Originally Posted by Gammix
Посмотреть сообщение
I think we are talking about efficiency here so yes variables are way faster than queries.

And whoever saying that saving all data at once can cause problem *sometimes* is competently wrong. Like this method has been followed since ages and there were no problems ever since.
Was mostly a problem before the threaded queries were implemented into the MySQL plugin by BlueG. So yes, it caused problems, as I have experienced 2-4 second lag each time everyone's stats were saved.

So I am not completely wrong, I just didn't make myself clear what I meant.
Also, Load Balancing is a thing for a reason - 500 players, with lets say 40 updated values on each player - it's not gonna go buttersmooth every time
Reply


Messages In This Thread
Mysql save wrong variables - mixing pSpawn and pSkin - by Saddin - 14.05.2017, 13:08
Re: Mysql save wrong variables - mixing pSpawn and pSkin - by Abagail - 14.05.2017, 13:15
Re: Mysql save wrong variables - mixing pSpawn and pSkin - by Saddin - 14.05.2017, 13:17
Re: Mysql save wrong variables - mixing pSpawn and pSkin - by Saddin - 14.05.2017, 16:47
Re: Mysql save wrong variables - mixing pSpawn and pSkin - by Vince - 14.05.2017, 16:59
Re: Mysql save wrong variables - mixing pSpawn and pSkin - by Saddin - 14.05.2017, 17:12
Re: Mysql save wrong variables - mixing pSpawn and pSkin - by coool - 14.05.2017, 17:16
Re: Mysql save wrong variables - mixing pSpawn and pSkin - by Dayrion - 14.05.2017, 18:29
Re: Mysql save wrong variables - mixing pSpawn and pSkin - by GoldenLion - 14.05.2017, 18:53
Re: Mysql save wrong variables - mixing pSpawn and pSkin - by Saddin - 14.05.2017, 19:22
Re: Mysql save wrong variables - mixing pSpawn and pSkin - by GoldenLion - 14.05.2017, 19:33
Re: Mysql save wrong variables - mixing pSpawn and pSkin - by Saddin - 14.05.2017, 19:55
Re: Mysql save wrong variables - mixing pSpawn and pSkin - by GoldenLion - 14.05.2017, 20:03
Re: Mysql save wrong variables - mixing pSpawn and pSkin - by Saddin - 14.05.2017, 20:09
Re: Mysql save wrong variables - mixing pSpawn and pSkin - by Dayrion - 14.05.2017, 23:00
Re: Mysql save wrong variables - mixing pSpawn and pSkin - by GoldenLion - 15.05.2017, 05:34
Re: Mysql save wrong variables - mixing pSpawn and pSkin - by Gammix - 15.05.2017, 06:36
Re: Mysql save wrong variables - mixing pSpawn and pSkin - by Tord - 15.05.2017, 10:17
Re: Mysql save wrong variables - mixing pSpawn and pSkin - by coool - 15.05.2017, 10:25
Re: Mysql save wrong variables - mixing pSpawn and pSkin - by Tord - 15.05.2017, 10:30
Re: Mysql save wrong variables - mixing pSpawn and pSkin - by Logic_ - 15.05.2017, 10:33
Re: Mysql save wrong variables - mixing pSpawn and pSkin - by GoldenLion - 15.05.2017, 11:41
Re: Mysql save wrong variables - mixing pSpawn and pSkin - by Gammix - 15.05.2017, 15:05
Re: Mysql save wrong variables - mixing pSpawn and pSkin - by Dayrion - 15.05.2017, 15:37
Re: Mysql save wrong variables - mixing pSpawn and pSkin - by Tord - 15.05.2017, 15:45
Re: Mysql save wrong variables - mixing pSpawn and pSkin - by Saddin - 15.05.2017, 22:01
Re: Mysql save wrong variables - mixing pSpawn and pSkin - by Tord - 16.05.2017, 00:20
Re: Mysql save wrong variables - mixing pSpawn and pSkin - by Saddin - 16.05.2017, 09:45

Forum Jump:


Users browsing this thread: 7 Guest(s)