Closed

Fix a DB query that's slowing down the site big time

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?

Skills: MySQL, Open Cart, PHP, Software Architecture

See more: auction site real time, sharing site development time cost, flash site load time, sql server query performance, reasons for slow website loading, how to find slow running query in sql server, wordpress slow database queries, optimize wordpress database queries, sql query optimization, how to speed up mysql queries in php, wordpress query optimization, fix php coding errors cross site scripting, optimise flash site loading time, flash site takes time load, mysql fix 2013 query, full flash site loading time, site big women, web query excel secure site, site tango time, site loading time flash

About the Employer:
( 0 reviews ) Ahmedabad, India

Project ID: #18880912

11 freelancers are bidding on average ₹1641 for this job

ntiersolutions

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 wa More

₹1500 INR in 1 day
(640 Reviews)
8.2
trinkaljuneja

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

₹5000 INR in 1 day
(220 Reviews)
6.9
devd22

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

₹1750 INR in 4 days
(210 Reviews)
5.8
xinglong717

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.

₹1450 INR in 1 day
(49 Reviews)
5.4
maverickindia

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% qua More

₹1300 INR in 2 days
(47 Reviews)
5.1
munjalmayank

Dear Customer, Greetings from Microprixs Solution! We have gone through the requirement and we can complete the same with given timeframe. We are one of the best team in Opencart, Wordpress / eCommerce (opencart / More

₹750 INR in 0 days
(90 Reviews)
5.0
psi55e57f5332ee0

i have great working experience in opencart and know very well how it work i am capable to do this with in your time frame and budget... before start we have to discuss little bit about requirement. some latest More

₹1500 INR in 1 day
(31 Reviews)
4.6
jkalivijay

Hi , I have 7+Years of experience in Opencart, so i can easily fix this slowness issues, Fine Tuning SQL Queries , you can also check my reviews and listed websites which is done by myself, List of Opencart More

₹1150 INR in 2 days
(14 Reviews)
3.8
Alwintech1

Hi , WE CAN FIX IT PERFECTLY Greetings! We have read and understood your need to review full description which extends the loading time , we can resolve this issue . We are confident about the work More

₹1300 INR in 1 day
(2 Reviews)
1.7
Denzel2

i am a web developer and work well with php, mysql and WordPress. I have 4 years experience in web development. I can get it done for you with 100% professionalism. Chat me up lets discuss your project. regards More

₹1250 INR in 3 days
(0 Reviews)
0.0
dvsmscit

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 More

₹1100 INR in 1 day
(0 Reviews)
0.0