From 075afe457c551d6725c358651e2a9059b8b1896d Mon Sep 17 00:00:00 2001
From: Jesusaves <cpntb1@ymail.com>
Date: Sat, 24 Feb 2024 15:57:21 -0300
Subject: picklog overhead takes ~42 seconds from mysql... Don't do it on
 query_sql.

---
 npc/003-3/malindou.txt | 6 ++++--
 1 file changed, 4 insertions(+), 2 deletions(-)

(limited to 'npc/003-3')

diff --git a/npc/003-3/malindou.txt b/npc/003-3/malindou.txt
index 2115bd3f8..18ecd3302 100644
--- a/npc/003-3/malindou.txt
+++ b/npc/003-3/malindou.txt
@@ -1044,8 +1044,10 @@ OnClock0500:
     }
     // TODO: Have crontab make monthly .gz backup?
     // Remove overhead from picklog
-    if (gettime(GETTIME_DAYOFMONTH) == 14)
-        query_sql("OPTIMIZE TABLE `picklog`");
+    if (gettime(GETTIME_DAYOFMONTH) == 14) {
+        apiasync("SQL", "OPTIMIZE TABLE `picklog`");
+        apiasync("SQLRUN", "");
+    }
     end;
 
 // This is for HUB
-- 
cgit v1.2.3-70-g09d2