Оптимизация запросов базы данных Opencart
Нужно оптимизировать ряд медленных и проблемных запросов к базе.
Сайт построен на Opencart 3 стоит тема Journal 3 и модуль OpenCart Lightning.
По Google PageSpeed 100/95.
Сайт стоит на VDS:
vCore x8
12 GB RAM ECC
В основном моменте проблема обработки запросов поиска товаров ниже скрины с модуля
-
Скорее всего оптимизация БД не поможет. Я имею ввиду, что доп. индексами не обойтись. Надо лезть в код.
По скрину видно конструкцию вида IN(1,2,3,4,) - это не очень хороший вариант.
-
Ну основная задача это вывести поиск товара и переход между страницами каталога на нормальную скорость
-
Пишите в ЛС, могу помочь.
-
Current freelance projects in the category Databases & SQL
Python/CAD Developer for automatic processing of DXF
178 USD
Development of a module for automatic labeling of parts in DXF for laser cutting is needed. Input data: - We use BAS for production accounting. - Laser cutting is performed on Senfeng with CypCut software. - We have ready layout files in DXF format. - Each part must receive a… Python, Databases & SQL ∙ 2 hours 38 minutes back ∙ 12 proposals |
Refinement of 1C UT 11 for Zebra TSD (RDP): different sound signals when scanning
22 USD
Configuration: 1C UT 11 Address warehouse Zebra TC26 TSD Work via RDP Product scanning is performed in receiving, placement, picking documents, and other warehouse operations. Current problem: Warehouse workers operate through the Zebra TSD. When scanning, they do not always… C#, Databases & SQL ∙ 14 hours 16 minutes back ∙ 5 proposals |
Heal the 1C configuration
111 USD
Configuration of CRM & ERP SmartCeiling (2.8.26.0) Protection via Registration Code. Registered until the end of the year. Databases & SQL ∙ 1 day 5 hours back ∙ 7 proposals |
Need a 1C specialist for refinements and development.I am looking for a 1C specialist for freelance collaboration. I am currently working with a contractor who provides support and maintenance for the 1C system. However, due to the contractor's workload, there is a need for prompt execution of additional tasks, improvements, and… Databases & SQL ∙ 6 days 4 hours back ∙ 12 proposals |
Restoring Instagram after a banOn March 3, 2026, my Instagram was blocked due to a violation of rules. I believe there has been some mistake, as the page was personal with photos and videos of my personal trips. I did not post any comments anywhere. I have sent several appeals. I cannot download my files… Databases & SQL, Web Programming ∙ 6 days 15 hours back ∙ 6 proposals |
Ukraine