summaryrefslogtreecommitdiff
path: root/npc
diff options
context:
space:
mode:
authorJesusaves <cpntb1@ymail.com>2023-03-28 09:05:53 -0300
committerJesusaves <cpntb1@ymail.com>2023-03-28 09:05:53 -0300
commit4d4c5d5a8a13de8c720264e045880e8f4dc127fb (patch)
treedab50cdc594dfd047631e44e994db6d49e18b3b6 /npc
parentc5879a844600bbfded6e6362368558460578952b (diff)
downloadserverdata-4d4c5d5a8a13de8c720264e045880e8f4dc127fb.tar.gz
serverdata-4d4c5d5a8a13de8c720264e045880e8f4dc127fb.tar.bz2
serverdata-4d4c5d5a8a13de8c720264e045880e8f4dc127fb.tar.xz
serverdata-4d4c5d5a8a13de8c720264e045880e8f4dc127fb.zip
Schedule optimizations, they're expected to happen in all active Evol2 serversHEADmaster
Diffstat (limited to 'npc')
-rw-r--r--npc/003-3/malindou.txt3
1 files changed, 3 insertions, 0 deletions
diff --git a/npc/003-3/malindou.txt b/npc/003-3/malindou.txt
index 6d0736a19..ba7673723 100644
--- a/npc/003-3/malindou.txt
+++ b/npc/003-3/malindou.txt
@@ -713,6 +713,9 @@ OnClock0500:
if (gettime(GETTIME_DAYOFMONTH) >= 7)
query_sql("DELETE FROM `chatlog` WHERE `time` < '"+sqldate(-7)+"'");
query_sql("DELETE FROM `picklog` WHERE `time` < '"+sqldate(0, -3)+"'");
+ // Remove overhead from picklog
+ if (gettime(GETTIME_DAYOFMONTH) == 14)
+ query_sql("OPTIMIZE TABLE `picklog`");
end;
// This is for HUB