Budget: 800 UAH Deadline: 1 day
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.
Budget: 1000 UAH Deadline: 1 day
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.
Budget: 1000 UAH Deadline: 1 day
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.
Serhii Motchany
Winning proposal- Projects 118
- Rating 5.0
- Rating 3 321
Budget: 500 UAH Deadline: 1 day
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.
Budget: 500 UAH Deadline: 1 day
Send the database, I'll take a look.
=- = -= -=- =- = -=- = -= -=- =- = -=- = -= -=- =- = -=- = -= -=- =- = -=- = -= -=- =- = -
Proposals are currently absent
Current freelance projects in the category Databases & SQL
-
335 USD
Automation of the entry of income invoices in 1C 8.3 via the API of the document recognition service
25 proposals 0:36
-
Not specified
Senior AI Systems Architect (Project Lead) Needed to Complete an Existing Unfinished Global Service
Gaming Apps 20 proposals 3 August
-
Not specified
Development of the CRM module "Requests" in custom 1C (bus center)
Client Management & CRM 20 proposals 31 July
-
22 USD
Support for Samotur and its servers
17 proposals 27 July
-
179 USD
Cleaning the client database in SIMLA CRM: phones, duplicates, cities
Client Management & CRM 43 proposals 27 July
