DB tweaking for performance

Question

Hi all,

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

Answer 1

Hello @H4mm2r and thank you for sharing !

You can contribute more effectively to the development of OCS Inventory by submitting your work on Github : Pull requests · OCSInventory-NG/OCSInventory-ocsreports (github.com)

Regards, Steph