Command lags the whole server
#5

Quote:
Originally Posted by Lordzy
Посмотреть сообщение
You're selecting every rows and columns to know the total players per ffaction. Here you're performing such query (sizeof(E_GROUP)) times that aren't even threaded ones. You could use GROUP BY clause to retrieve the information you're looking for.
pawn Код:
SELECT `COUNT(*)`, `Member` FROM `players` GROUP BY `Member`
You can even avoid looping using such a query, unless this isn't what that you really want.
What Lordzy said is right, i just wanted to point out that you should use threaded queries
Reply


Messages In This Thread
Command lags the whole server - by danielpalade - 10.01.2017, 00:12
Re: Command lags the whole server - by BiosMarcel - 10.01.2017, 00:29
Re: Command lags the whole server - by danielpalade - 10.01.2017, 01:40
Re: Command lags the whole server - by Lordzy - 10.01.2017, 01:55
Re: Command lags the whole server - by BiosMarcel - 10.01.2017, 15:45
Re: Command lags the whole server - by danielpalade - 10.01.2017, 16:51
Re: Command lags the whole server - by Vince - 10.01.2017, 17:12
Re: Command lags the whole server - by danielpalade - 10.01.2017, 17:19
Re: Command lags the whole server - by Vince - 10.01.2017, 21:21
Re: Command lags the whole server - by danielpalade - 10.01.2017, 22:10

Forum Jump:


Users browsing this thread: 1 Guest(s)