Fix a DB query that's slowing down the site big time
₹600-1500 INR
Imefungwa
Imechapishwa about 5 years ago
₹600-1500 INR
Kulipwa wakati wa kufikishwa
Website is built on OPENCART 3.0 with Fastor theme.. Site (and admin) is loading very slow and sometimes throws various HTTP timeout errors (500,504)... i had faced similar kind of problem on a previous site, and had set up a slow_query_log because Opencart has a DB query that fetches product total count that's taking >10 seconds everytime it loads. And it also clogs the website speed and is bringing it down:
1) DB QUERY
SELECT COUNT(DISTINCT p.product_id)
AS total FROM oc_category_path
cp LEFT JOIN oc_product_to_category p2c ON
(cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND [login to view URL] = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '222';
Need to identify which FILE is calling this query and fix it in backend. The problem is happening because I have > 25000 products on my site.. I just want to know what other precautions to take ( eg.. is there any other queries that need to be taken care of) so that I can continue to add more products to my website..
2) [login to view URL]
The above Blog says that three files in catalog/controller needs to be fixed. But these files are not there in my web-files under the directories specified. Also, there are some other forums that say it's the MODEL file and not the CONTROLLER file that needs to be changed. Also, I want to know if there's any file in the ADMIN MVC files that need to be changed, because admin is also not loading properly?
Hi,
I am Opencart expert. I can fix that sql query in this job to load admin faster. It may be possible that there are more queries, but this bid is only for fixing the query mentioned in job description.
If you want complete opencart optimization then it will cost around Rs. 10000
Thanks
Harsh
Hello.
I have read your project note.
But I think we can talk through chatting.
Because your project note did not realized by me at a glance.
I am sorry.
Look forward to your response.
Hi, I am interested in this project.
Just check my review of work and give me an opportunity to prove myself. Please consider my bid. Thanks & Regards Dev
Dear Client,
Before Awarding to Anyone give me a chance & kindly discuss your project in detail with me.
I have read your requirement carefully and got total understanding of the project .No fake commitment,100% quality work.
I have more than 8 years of experience in IT Services. I am always available on Email, WhatsApp and Skype. Please have a voice or video chat if necessary.
I will be available more than 40 hours per week and able to start your project immediately after finalization. Thank you for taking the time to read my application. I look forward to talking with you.
Nikhil Singh
Hello,
I have gone through your requirement and clearly understood your requirement and I'll optimise mysql query and improve performance of the site.
I have been working in opencart more than 5.5+ years. I have good & vast experience in opencart 1.x to 3.x latest version. Also I have worked on all famous opencart theme like pavilion, journal, foaster etc.., Also have keen eye for designing.
You can confirm my skills on my profile page as well I am glad to share my opencart work portfolio if you want to review.
I look forward to your response.
Thanks,
Darshan