Hey i noticed that im getting dispatcher log of sql_slow saying my tile_store considered to be slow. As far as i understand its items on the tile that causing it to show as a laggy, or im just delusional and 11-17 considered to be decent, but if not maybe there is somekind of comit released for optimizing it a bit more? Using TFS 1.2
SQL:
[30/10/2023 17:01:16] Execution time: 11 ms - INSERT INTO `tile_store` (`house_id`, `data`) VALUES (33,'Ū\0+\0\0\0¸\0'),(34,'Ū\0L\0\0\0¸\0 - INSERT INTO `tile_store` (`house_id`, `data`) VALUES (33,'Ū\0+\0\0\0¸\0'),(34,'Ū\0L\0\0\0¸\0'),(35,'å\0!\0\0\0‘\0'),(36,'ć\07\0\0\0‘\0'),(37,'ķ\0I\0\0\0‘\0'),(38,'ł\0E\0\0\0¸\0'),(39,'ń\0(\0\0\0‘\0'),(40,'ī\0\0\0\0¸\0'),(41
[30/10/2023 17:01:16] Execution time: 16 ms - UPDATE `houses` SET `owner` = 0, `paid` = 0, `warnings` = 0, `name` = 'House #115', `town_id` = 1, ` - UPDATE `houses` SET `owner` = 0, `paid` = 0, `warnings` = 0, `name` = 'House #115', `town_id` = 1, `rent` = 0, `size` = 37, `beds` = 0 WHERE `id` = 115
[30/10/2023 17:03:56] Execution time: 19 ms - DELETE FROM `player_misc` WHERE `player_id` = 62 - DELETE FROM `player_misc` WHERE `player_id` = 62
[30/10/2023 21:04:17] Execution time: 10 ms - DELETE FROM `player_misc` WHERE `player_id` = 62 - DELETE FROM `player_misc` WHERE `player_id` = 62
[31/10/2023 03:06:08] Execution time: 24 ms - DELETE FROM `house_lists` - DELETE FROM `house_lists`
[31/10/2023 05:06:08] Execution time: 10 ms - INSERT INTO `tile_store` (`house_id`, `data`) VALUES (33,'Ū\0+\0\0\0¸\0'),(34,'Ū\0L\0\0\0¸\0 - INSERT INTO `tile_store` (`house_id`, `data`) VALUES (33,'Ū\0+\0\0\0¸\0'),(34,'Ū\0L\0\0\0¸\0'),(35,'å\0!\0\0\0‘\0'),(36,'ć\07\0\0\0‘\0'),(37,'ķ\0I\0\0\0‘\0'),(38,'ł\0E\0\0\0¸\0'),(39,'ń\0(\0\0\0‘\0'),(40,'ī\0\0\0\0¸\0'),(41
[31/10/2023 09:06:08] Execution time: 11 ms - INSERT INTO `tile_store` (`house_id`, `data`) VALUES (33,'Ū\0+\0\0\0¸\0'),(34,'Ū\0L\0\0\0¸\0 - INSERT INTO `tile_store` (`house_id`, `data`) VALUES (33,'Ū\0+\0\0\0¸\0'),(34,'Ū\0L\0\0\0¸\0'),(35,'å\0!\0\0\0‘\0'),(36,'ć\07\0\0\0‘\0'),(37,'ķ\0I\0\0\0‘\0'),(38,'ł\0E\0\0\0¸\0'),(39,'ń\0(\0\0\0‘\0'),(40,'ī\0\0\0\0¸\0'),(41
[31/10/2023 15:06:08] Execution time: 10 ms - INSERT INTO `tile_store` (`house_id`, `data`) VALUES (33,'Ū\0+\0\0\0¸\0'),(34,'Ū\0L\0\0\0¸\0 - INSERT INTO `tile_store` (`house_id`, `data`) VALUES (33,'Ū\0+\0\0\0¸\0'),(34,'Ū\0L\0\0\0¸\0'),(35,'å\0!\0\0\0‘\0'),(36,'ć\07\0\0\0‘\0'),(37,'ķ\0I\0\0\0‘\0'),(38,'ł\0E\0\0\0¸\0'),(39,'ń\0(\0\0\0‘\0'),(40,'ī\0\0\0\0¸\0'),(41
[01/11/2023 00:10:39] Execution time: 12 ms - INSERT INTO `tile_store` (`house_id`, `data`) VALUES (33,'Ū\0+\0\0\0¸\0'),(34,'Ū\0L\0\0\0¸\0 - INSERT INTO `tile_store` (`house_id`, `data`) VALUES (33,'Ū\0+\0\0\0¸\0'),(34,'Ū\0L\0\0\0¸\0'),(35,'å\0!\0\0\0‘\0'),(36,'ć\07\0\0\0‘\0'),(37,'ķ\0I\0\0\0‘\0'),(38,'ł\0E\0\0\0¸\0'),(39,'ń\0(\0\0\0‘\0'),(40,'ī\0\0\0\0¸\0'),(41
[01/11/2023 00:39:12] Execution time: 11 ms - SELECT `id` FROM `houses` WHERE `id` = 33 - SELECT `id` FROM `houses` WHERE `id` = 33
[01/11/2023 02:39:12] Execution time: 12 ms - INSERT INTO `tile_store` (`house_id`, `data`) VALUES (33,'Ū\0+\0\0\0¸\0'),(34,'Ū\0L\0\0\0¸\0 - INSERT INTO `tile_store` (`house_id`, `data`) VALUES (33,'Ū\0+\0\0\0¸\0'),(34,'Ū\0L\0\0\0¸\0'),(35,'å\0!\0\0\0‘\0'),(36,'ć\07\0\0\0‘\0'),(37,'ķ\0I\0\0\0‘\0'),(38,'ł\0E\0\0\0¸\0'),(39,'ń\0(\0\0\0‘\0'),(40,'ī\0\0\0\0¸\0'),(41
[01/11/2023 08:39:12] Execution time: 13 ms - INSERT INTO `tile_store` (`house_id`, `data`) VALUES (33,'Ū\0+\0\0\0¸\0'),(34,'Ū\0L\0\0\0¸\0 - INSERT INTO `tile_store` (`house_id`, `data`) VALUES (33,'Ū\0+\0\0\0¸\0'),(34,'Ū\0L\0\0\0¸\0'),(35,'å\0!\0\0\0‘\0'),(36,'ć\07\0\0\0‘\0'),(37,'ķ\0I\0\0\0‘\0'),(38,'ł\0E\0\0\0¸\0'),(39,'ń\0(\0\0\0‘\0'),(40,'ī\0\0\0\0¸\0'),(41
[01/11/2023 10:39:12] Execution time: 17 ms - INSERT INTO `tile_store` (`house_id`, `data`) VALUES (33,'Ū\0+\0\0\0¸\0'),(34,'Ū\0L\0\0\0¸\0 - INSERT INTO `tile_store` (`house_id`, `data`) VALUES (33,'Ū\0+\0\0\0¸\0'),(34,'Ū\0L\0\0\0¸\0'),(35,'å\0!\0\0\0‘\0'),(36,'ć\07\0\0\0‘\0'),(37,'ķ\0I\0\0\0‘\0'),(38,'ł\0E\0\0\0¸\0'),(39,'ń\0(\0\0\0‘\0'),(40,'ī\0\0\0\0¸\0'),(41
[01/11/2023 12:04:12] Execution time: 12 ms - SELECT * FROM z_ots_comunication; - SELECT * FROM z_ots_comunication;
[01/11/2023 16:39:12] Execution time: 10 ms - INSERT INTO `tile_store` (`house_id`, `data`) VALUES (33,'Ū\0+\0\0\0¸\0'),(34,'Ū\0L\0\0\0¸\0 - INSERT INTO `tile_store` (`house_id`, `data`) VALUES (33,'Ū\0+\0\0\0¸\0'),(34,'Ū\0L\0\0\0¸\0'),(35,'å\0!\0\0\0‘\0'),(36,'ć\07\0\0\0‘\0'),(37,'ķ\0I\0\0\0‘\0'),(38,'ł\0E\0\0\0¸\0'),(39,'ń\0(\0\0\0‘\0'),(40,'ī\0\0\0\0¸\0'),(41
[01/11/2023 18:19:42] Execution time: 12 ms - SELECT * FROM z_ots_comunication; - SELECT * FROM z_ots_comunication;
[01/11/2023 18:39:12] Execution time: 10 ms - INSERT INTO `tile_store` (`house_id`, `data`) VALUES (33,'Ū\0+\0\0\0¸\0'),(34,'Ū\0L\0\0\0¸\0 - INSERT INTO `tile_store` (`house_id`, `data`) VALUES (33,'Ū\0+\0\0\0¸\0'),(34,'Ū\0L\0\0\0¸\0'),(35,'å\0!\0\0\0‘\0'),(36,'ć\07\0\0\0‘\0'),(37,'ķ\0I\0\0\0‘\0'),(38,'ł\0E\0\0\0¸\0'),(39,'ń\0(\0\0\0‘\0'),(40,'ī\0\0\0\0¸\0'),(41
[01/11/2023 19:22:42] Execution time: 11 ms - SELECT * FROM z_ots_comunication; - SELECT * FROM z_ots_comunication;
[01/11/2023 20:39:12] Execution time: 12 ms - INSERT INTO `tile_store` (`house_id`, `data`) VALUES (33,'Ū\0+\0\0\0¸\0'),(34,'Ū\0L\0\0\0¸\0 - INSERT INTO `tile_store` (`house_id`, `data`) VALUES (33,'Ū\0+\0\0\0¸\0'),(34,'Ū\0L\0\0\0¸\0'),(35,'å\0!\0\0\0‘\0'),(36,'ć\07\0\0\0‘\0'),(37,'ķ\0I\0\0\0‘\0'),(38,'ł\0E\0\0\0¸\0'),(39,'ń\0(\0\0\0‘\0'),(40,'ī\0\0\0\0¸\0'),(41