We have been upgrading 2.11.1 OCS server and we still have performance issue link to the software table.
In order to solve this issue, we added a key to this table:
ALTER TABLE `software`
ADD PRIMARY KEY (`ID`),
ADD KEY `HARDWARE_ID` (`HARDWARE_ID`),
ADD KEY `NAME_ID` (`NAME_ID`),
ADD KEY `PUBLISHER_ID` (`PUBLISHER_ID`),
ADD KEY `VERSION_ID` (`VERSION_ID`),
ADD KEY `HARDWARE_ID_2` (`HARDWARE_ID`,`NAME_ID`,`VERSION_ID`) USING BTREE;
With this change, no more slowness. Maybe it could be helpful to bring it by default into the codebase.
Pull requet created https://github.com/OCSInventory-NG/OCSInventory-ocsreports/pull/1530