Website speed optimization on Opencart

Databases & SQL, PHP — incorrectly specified categories?

Project translated automatically. Log in or register, to view the original

There is a store on Opencart 3.0.3.1, with 57K products. When there were 7K products, it worked well, but after adding the remaining products, it started to open slowly, and when searching for a product on the site, the search icon spins for a long time.

I wrote to the hosting support, here is the response

In this case, it is necessary to optimize the SQL queries from the site to the database, as well as to conduct a review (cleaning the database) of unnecessary records and products.
The established PHP limits are sufficient for the operation of the website.

I will send the link to the site in a private message

Proposals 9 Discussions 1

Yevhenii Tykhonov

16 0

Projects 18
Rating -
Rating 805

Budget: 14999 UAH Deadline: 10 days

Hello!

Optimizing your website on Opencart is a task I am ready to help with. Given the number of products, it is important to focus on optimizing SQL queries and cleaning the database of unnecessary records. This will significantly improve search speed and the overall performance of the store.

I will gladly conduct an audit and suggest specific steps to improve the performance of your website. I am waiting for a link to the resource for a more detailed analysis.

Best regards.

Vitaly But

80 1

Budget: 4000 UAH Deadline: 5 days

Change hosting
Trust a professional with over 10 years of experience! The rate and deadlines are current!
I will be glad to cooperate!
Experience in commercial development of online stores on CMS, business portals, and corporate websites - 11 years!
+CMS: WordPress(+Woocommerce) PrestaShop/Opencart/Joomla/Bitrix/MODX/DLE/Shopify
php/html/css/js/Mysql, PhotoShop/Figma
Examples of work (from scratch, turnkey):
https://nordtrade.online/
https://v12coffee.com.ua/franchise/
https://binam.pro
https://sengero.no/
https://beautybysim.no/
https://www.emmanuel.com.ua/
https://www.onsitecomputersinc.com/
https://express-tehbud.com/
http://www.alternativemedicine.com.ua/
https://korostenporcelain.com.ua/
https://sladok.com.ua/
https://pricemds.com/
https://picupmedia.com/
https://www.serasar.com/
https://integrisit.com/
https://franklinitsolutions.com/
https://www.raebel-latzke.ch/

Roman Matvii

67 0

Budget: 5000 UAH Deadline: 1 day

Hello! I will complete your task quickly and efficiently.

My portfolio: https://freelancehunt.com/ua/freelancer/romas6ka.html#portfolio
Write to me. I will be happy to collaborate with you!

Vladyslav H.

80 0

Projects 81
Rating -
Rating 2 856

Budget: 500 UAH Deadline: 1 day

Good day, I can speed it up right now, before payment - write in private.

Maksim S.

15 0

Budget: 500 UAH Deadline: 1 day

Hello, please familiarize yourself with the website in more detail. I have set up improvements for the operation of such stores more than once, but I need more details.

Serhii Samoylo

1 0

Projects -
Rating -
Rating 380

Budget: 1000 UAH Deadline: 1 day

To assess the cost of the work, it is necessary to see the volume. If you want, contact me on Telegram, show what is slowing you down, and we will discuss the volume and cost of the work.