When i click on Inventory - > All software function is very slow in ocs server 2.8.
it's taking too much time for process.
MariaDB [(none)]> show processlist ;
+----+------+-----------+--------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+----+------+-----------+--------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+----------+
| 2 | root | localhost | NULL | Query | 0 | NULL | show processlist | 0.000 |
| 3 | root | localhost | ocsweb | Sleep | 16 | | NULL | 0.000 |
| 4 | root | localhost | ocsweb | Query | 16 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS *, count(CONCAT(s.NAME_ID,"_", s.VERSION_ID)) as nb, CONCAT(n.NAME,";", | 0.000 |
+----+------+-----------+--------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+----------+
3 rows in set (0.00 sec)
Please provide me solution.
