Optimization of database operation in CMS OkayCMS 4.3.1

In the process of adding goods, difficulties appeared, in the form of a slowdown in the import of goods. The more products were added to the catalog, the slower the imports took place. And also the functionality of the site began to work very slowly.

• Primary goal. solve the problem of slow operation of the functionality of the user part of the CMS (catalog, product filter, search, speed of display of the live search list)

• The second goal, in the admin panel, is to solve the problem with the speed of importing new products and updating the characteristics of existing in the product database by opening the properties section in the catalog section