Find Jobs
Hire Freelancers

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?
Kitambulisho cha mradi: 18880912

Kuhusu mradi

9 mapendekezo
Mradi wa mbali
Inatumika 5 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
9 wafanyakazi huru wana zabuni kwa wastani ₹1,722 INR kwa kazi hii
Picha ya Mtumiaji
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
₹1,500 INR ndani ya siku 1
4.9 (660 hakiki)
8.3
8.3
Picha ya Mtumiaji
the issue you mention is not present in OC3.0 , it was in OC.2.X but i can check other sql queries slowing down your site
₹5,000 INR ndani ya siku 1
4.9 (224 hakiki)
6.9
6.9
Picha ya Mtumiaji
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.
₹1,450 INR ndani ya siku 1
4.9 (68 hakiki)
5.9
5.9
Picha ya Mtumiaji
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
₹1,750 INR ndani ya siku 4
5.0 (211 hakiki)
5.8
5.8
Picha ya Mtumiaji
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
₹1,300 INR ndani ya siku 2
4.8 (54 hakiki)
5.6
5.6
Picha ya Mtumiaji
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
₹1,100 INR ndani ya siku 1
0.0 (0 hakiki)
0.0
0.0

Kuhusu mteja

Bedera ya INDIA
Chennai, India
0.0
0
Njia ya malipo imethibitishwa
Mwanachama tangu Nov 1, 2018

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.