and Opencart. Optimize the size of BD and SQL requests

Hello to you. I have experience in developing complex filters to promote the site. I can check your database and indicate the cause of slow downloads. Write in personal messages for discussion.

Show original

Translate

First, you need to look at the database, its structure, and how it was designed. Reducing the size is not quite understandable (not enough space on the disk to store data?The base can only be reduced by the volume of data (the data you fill the base yourself), the relevance of the data in one or another table and the changes in the structure, namely the types of fields, index. The types of fields that are selected, the size of the memory taken may be excessive to store information that does not require it, plus the size of the indices if they were naturally created.

Plus for optimization, you need to understand how requests are written! If they are written through a pure SQL, it’s a moment if through CMS it makes history difficult and then you’ll have to rewrite the approach to writing requests.

Any problem is solved, any problem is overcome. We can discuss technical issues and we can move forward!

Show original

Translate

Good day !
The first point, I don’t say, I don’t know
As for other points, with such they met when they worked on a large project on Yii for one of the fin.companies, really there was the project self-written. It was necessary to analyze, change logic, sometimes, hopefully, it was necessary to change in the table data types, change requests, etc.
Here you need to understand how requests were created.
If requests are created directly by the engine, then it’s more difficult, as riding into the core of the framework is unlikely someone will, if requests were created already directly when adapting to your store, then you can look and upgrade.
Look at the project and understand it.

Show original

Translate

Hello to you!
100% ready to fulfill your order.
- Quality work
Experience in work over 5 years
Agreement of price
Permanent feedback
I'm looking forward to your message, write and discuss details.

Telegram Gharakeshishyan

Show original

Translate