• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Most powerfull guilds

xLosT

xLosT

Member
Joined
Jan 11, 2010
Messages
1,021
Reaction score
13
Location
Brasil, Rio Grande do Sul
my server is war, has more than 1 million of frags in database, if I add Most powerfull guilds starting to lag server, but see other server that has this system and not the lag.

my vps
CPU - MHz:
4 - 6000MHz
Memoria:
8192MB
Sistema Operacional:
Ubuntu Linux (64-bit)
 
Sort by date Sort by votes
check whoisonline for cache, then implement it for top guilds

you can't do anything to speed it up, except for deleting old deaths (older than a month?)
SQL: 
delete from player_deaths where date < UNIX_TIMESTAMP() - 30*86400;
delete from killers where death_id not in (select id from player_deaths);
delete from environment_killers where kill_id not in (select id from killers);
delete from player_killers where kill_id not in (select id from killers);
 
Upvote 0 Downvote
Back
Top