Оптимизация sql запроса Opencart
Запрос всего лишь делает выборку товаров по акции в категории с разбивкой на страницы, но запрос занимает 11 сек, т.к в категории 130000 товара, нужна оптимизация
запрос http://prntscr.com/nts3ao
-
1 day7 USD
9 1 day7 USD
Поскольку, с первого взгляда, скрипт написан корректно, необходимо ознакомиться с структурой таблиц, которые участвуют в запросе.
Готов взяться за Ваше задание, по улучшению скрипта.
-
1 day28 USD
1658 61 2 1 1 day28 USD
Здравствуйте,
смогу переписать запрос, чтобы ускорить выборку товаров
-
1 day14 USD
27216 533 19 7 1 day14 USD
Здравствуйте, готов сделать, если актуально - напишите мне..
Current freelance projects in the category Databases & SQL
Data automation and visualizationIt is necessary to develop a visual representation of numerical data, to design and implement the output and update of visualizations on the company's screens. HTML & CSS, Databases & SQL ∙ 12 hours 48 minutes ago ∙ 10 proposals |
Parsing data about cemeteries for the WordPress site databaseIt is necessary to collect and structure data about cemeteries from several sources to create a database that can be integrated into a website on the WordPress platform. Task: Data collection from Google and specialized websites, including: Cemetery names. Geographical location.… Databases & SQL, Data Parsing ∙ 15 hours 33 minutes ago ∙ 3 proposals |
Finalize the mobile application (flutter) that works using firebase.Task 1. Improve the mobile application (flutter) that works with firebase - specifically, add a search line (highlighted in red - like Google search among the database and the array of data collected by the application - clients and order histories) Task 2. Improve the… Databases & SQL, Apps for iOS (iPhone and iPad) ∙ 1 day ago ∙ 4 proposals |
Accounting table for tracking income and expenses and payroll payments
24 USD
A Google spreadsheet needs to be created that will automatically calculate salaries for company employees based on their place of employment. Each employee has their own table from which this information should be linked via Hyperlink. Each place of employment should have a… Databases & SQL, Accounting Services ∙ 1 day 4 hours ago ∙ 9 proposals |
Task 1: Fix lag issues on the website Task 2: Develop a full product page
40 USD
№1Requirements Experience with Vue.js, performance optimization, and debugging. Experience in optimizing frontend applications for speed and responsiveness.Expected Results Detailed analysis of lag causes (e.g., inefficient components, large assets, etc.). Optimized code or… Javascript and Typescript, Databases & SQL ∙ 1 day 7 hours ago ∙ 5 proposals |