From 4d4c5d5a8a13de8c720264e045880e8f4dc127fb Mon Sep 17 00:00:00 2001 From: Jesusaves Date: Tue, 28 Mar 2023 09:05:53 -0300 Subject: Schedule optimizations, they're expected to happen in all active Evol2 servers --- npc/003-3/malindou.txt | 3 +++ 1 file changed, 3 insertions(+) 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 -- cgit v1.2.3-60-g2f50