Optimization of MySQL for OpenCart
During the visit to the site, the load on mysql is sharply increasing, I suggest that the problem in heavy data base requests, it is necessary to analyze and optimize them.
You need to analyze current requests to change them if necessary. Further, under certain requests, you need to create indices in the database. The optimization of the queries themselves + index sampling gives a good result.
Freelancer's review of cooperation with client
Optimization of MySQL for OpenCartThe customer quickly delivered all the materials and access, the payment was made instantly. pleasant in communication. I recommend to everyone!
-
4057 256 0 2 Hello to you.
Ready to start implementing immediately after approval of the project, there is such experience. I will perform the correct setting of the server, MySQL, as well as I will leave the indices for requests. We can also place the base in the cloud, but first you need to look at the server.
Current freelance projects in the category Databases & SQL
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 ∙ 10 hours 45 minutes back ∙ 9 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 ∙ 21 hours 52 minutes back ∙ 4 proposals |
It is necessary to upload products into the corresponding categories and subcategories from SQL files.The site is created on WP. It has a product catalog. Products were uploaded from a PDF file, resulting in a bit of a mess. There are three files with a clear distribution of categories, subcategories, and products in them. In the file PA.sql, categories are numbered, for… Databases & SQL, Web Programming ∙ 1 day 1 hour back ∙ 34 proposals |
CRM system for Railway LogisticsCreation of a CRM system for a logistics company mainly focused on rail and road transport, 1) Financial reporting 2) Processing applications 3) Contractors 4) Automatic issuance of invoices and acts upon closure, it is possible to create a simplified system based on 1C below… Databases & SQL, Client Management & CRM ∙ 1 day 9 hours back ∙ 38 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 ∙ 4 days 4 hours back ∙ 16 proposals |