Оптимізувати роботу хостингу з базою даних SQL
56 USDСайт https://kerasan.shop/
На хостингу Україна потрібно оптимізувати роботу з базою даних SQL ( у мене є повільні запити які спричиняють зависання роботи сайту )
Потрібно виправити помилки в SQL базі таблиць та оптимізувати швидкість роботи.
Потійсно підвисає коли до бази є 62 запити
2. Оптимізація SQL-запитів для пришвидчення роботи сайту
Приклади помилок.
SELECT
DISTINCT p.product_id
FROM
`oc_category_path` cp
LEFT JOIN `oc_product_to_category` p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN `oc_product` p ON (p2c.product_id = p.product_id)
LEFT JOIN `oc_product_description` pd ON (p.product_id = pd.product_id)
LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id)
WHERE
pd.language_id = '3'
AND p.status = '1'
AND p.date_available <= NOW()
AND p2s.store_id = '0'
GROUP BY
p.product_id
ORDER BY
p.date_added DESC,
LCASE(pd.name) DESC
LIMIT
0, 10
Work results
Client's review of cooperation with Ruslan T.
Оптимізувати роботу хостингу з базою даних SQLTHANK YOU Ruslan! I am satisfied with the work, everything was done quickly, even faster than the stated deadline. He consulted me on the issue and advised the next steps for stable and proper operation. All slow requests that were burdening the hosting system have been fixed. I am satisfied with the work. I recommend.
Freelancer's review of cooperation with Yurii Hmelevsky
Оптимізувати роботу хостингу з базою даних SQLGreat client.
Interesting task.
No issues with payment.
I recommend 🙂
-
1 day45 USD
3367 148 4 1 1 day45 USD
Good day.
I have already done this in OpenCart.
If you have any questions, you can write to me in private messages.
-
2 days47 USD
2130 199 1 4 2 days47 USD
Contact me - I will do my best.
20+ years of administration experience.
Examples of clients for whom I have configured and support servers can be viewed on my website and in my portfolio on this exchange.
If desired, work under a contract with payment to a bank account is possible (I am a private entrepreneur, group 3).
30% of the money earned at this rate will be donated to support the Armed Forces of Ukraine.
-
групбай з дістінктом це безполезна операція це ж те саме .
перевірте індекси, може їх перестворити треба та й буде вам щастя , якщо сервер звісно ресурси має.
-
Current freelance projects in the category Databases & SQL
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 ∙ 1 day 2 hours 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 17 hours back ∙ 8 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 17 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 ∙ 7 days 4 hours back ∙ 6 proposals |
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 10 days 11 hours back ∙ 16 proposals |
Lvov