Оптимізація SQL запиту(Opencart 3.0.3.2)
11 USDПривіт!
Потрібно оптимзівути запит до бази даних
SQL
SELECT
COUNT(DISTINCT p.product_id) AS total
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 = '1'
AND p.status = '1'
AND p.date_available <= NOW()
AND p2s.store_id = '0'
AND cp.path_id = '99'
Client's review of cooperation with Serhii Motchany
Оптимізація SQL запиту(Opencart 3.0.3.2)The work was done quickly and efficiently!
Freelancer's review of cooperation with Pavlo Podberezko
Оптимізація SQL запиту(Opencart 3.0.3.2)Very cool client.
Clearly set the task, was always in touch.
I plan to work with this client more than once.
I recommend everyone to collaborate.
-
1 day18 USD
1848 43 0 1 day18 USD
To begin with: why do a LEFT JOIN, you can do an INNER JOIN, look at the indexing of the tables, and then - already in private communication.
-
1 day22 USD
2881 80 0 1 day22 USD
The slow operation of the site is related to this request, but there is another option to change it without breaking the logic and speed. Write to me privately to explain, with one option the site will work like lightning.
-
1 day22 USD
4926 88 0 1 day22 USD
Good day, Pavlo
I propose the following options:
1. setting up indexing in the tables oc_category_path and oc_product_to_category.
2. remove unnecessary left joins and replace them with inner joins.
Write in private messages, we will discuss the details.
-
Winning proposal1 day11 USD
3367 148 4 1 Winning proposal1 day11 USD
Good day.
I have already corrected such requests. It is necessary to create indexes.
If you have any questions, you can write to me in private messages.
-
1 day11 USD
2593 427 9 1 1 day11 USD
Send the database, I'll take a look.
=- = -= -=- =- = -=- = -= -=- =- = -=- = -= -=- =- = -=- = -= -=- =- = -=- = -= -=- =- = -
Current freelance projects in the category Databases & SQL
Basketball Coaching Education Platform + Custom CMSBasketball Coaching Education Platform + Custom CMSProject Overview We are looking for an experienced web development team or full-stack developer to build a modern basketball coaching education platform. The website will provide basketball coaches with access to educational… Databases & SQL, Web Programming ∙ 15 hours 59 minutes back ∙ 63 proposals |
Integration of Viber in 8.3
223 USD
Need Viber integration into own CRM (1C 8.3)About the Company The company "Domofon System" is engaged in the installation and maintenance of intercom systems. Base of over 40,000 subscribers. We work on our own customized system based on 1C 8.3. We are looking for a specialist… Databases & SQL, Bot Development ∙ 19 hours 21 minutes back ∙ 10 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 ∙ 2 days 17 hours back ∙ 6 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 ∙ 3 days 8 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 ∙ 8 days 7 hours back ∙ 12 proposals |
Zaporizhzhia