Kapalı

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?

Beceriler: MySQL, Open Cart, PHP, Yazılım Mimarisi

Daha fazlasını gör: 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

İşveren Hakkında:
( 0 değerlendirme ) Ahmedabad, India

Proje NO: #18880912

Bu iş için 11 freelancer ortalamada ₹1641 teklif veriyor

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(640 Değerlendirme)
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(220 Değerlendirme)
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 gün içinde
(210 Değerlendirme)
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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(49 Değerlendirme)
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 Daha Fazla

₹1300 INR in 2 gün içinde
(47 Değerlendirme)
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 / Daha Fazla

₹750 INR in 0 gün içinde
(90 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(31 Değerlendirme)
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 Daha Fazla

₹1150 INR in 2 gün içinde
(14 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(2 Değerlendirme)
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 Daha Fazla

₹1250 INR in 3 gün içinde
(0 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(0 Değerlendirme)
0.0