Hello people, i am having a very repetitive query in my database, this query is every second and it comes from duplicates. This query is making the tool very slow.
The query is the following:
SELECT HARDWARE_ID,DESCRIPTION,MACADDR FROM networks WHERE MACADDR='XXXXXX' AND HARDWARE...
The version of my OCS is 2.7 and my MYSQL is 5.7
I appreciate any help.