Latest update
| Execute | 18 | executing | select `assets`.*, (select `created_at` from `action_logs` where `item_id` = `assets`.`id` and `item
-- | -- | -- | -- | --
Lately, when searching items in manufacturers, or models, its extremely laggy and mysql db is blowing up. Its taking at least 60 Seconds to bring up a list. I cant work out what the problem is.
Currently I have 213,027 rows in action logs, but it shouldn't be this slow. Only happened recently. Any ideas?
PHP Version:
8.2.30
Snipe-IT version:
v8.3.7 build 20803 (gdba8cb83b)
Latest update
| Execute | 18 | executing | select `assets`.*, (select `created_at` from `action_logs` where `item_id` = `assets`.`id` and `item -- | -- | -- | -- | --Lately, when searching items in manufacturers, or models, its extremely laggy and mysql db is blowing up. Its taking at least 60 Seconds to bring up a list. I cant work out what the problem is.
Currently I have 213,027 rows in action logs, but it shouldn't be this slow. Only happened recently. Any ideas?
PHP Version:
8.2.30
Snipe-IT version:
v8.3.7 build 20803 (gdba8cb83b)