• Projects 44
  • Rating -
  • Rating 1 816

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.

  • Projects 81
  • Rating -
  • Rating 2 881

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.

  • Projects 89
  • Rating 5.0
  • Rating 4 819

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

Serhii Motchany

Winning proposal
149 4
  • 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.

  • Projects 421
  • Rating 4.7
  • Rating 2 530

Budget: 500 UAH Deadline: 1 day

Send the database, I'll take a look.
=- = -= -=- =- = -=- = -= -=- =- = -=- = -= -=- =- = -=- = -= -=- =- = -=- = -= -=- =- = -

The list does not show proposals concealed by the client or freelancer with a Plus profile, as well as proposals violating rules

Current freelance projects in the category Databases & SQL

  1. 335 USD
  2. Not specified
  3. Not specified
  4. 22 USD
  5. 179 USD