Kapalı

ZENCART SQL Slow Query Fix.

My site always got throttled and the server supplier said it was because my MYSQL's bad queries. Here is the info. they offered. I have other slow queries for you to check. I need SQL to be fixed without such slow queries anymore.

bad queries such as this: select p.products_id, p.products_type,p.products_status,p.products_price ,p.products_price_retail,p.products_price_sample,p .product_is_wholesale,p.product_wholesale_min,[url removed, login to view] oducts _quantity, p.products_quantity_order_min, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_de script ion, IF([url removed, login to view] = 1, [url removed, login to view] ls_new_products_price, NULL) as specials_new_products_price, IF([url removed, login to view] =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_c all, p.product_is_always_free_shipping, p.products_qty_box_status from products_de script ion pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and ( p2c.categories_id =1 or p2c.categories_id =7 or p2c.categories_id =184 or p2c.categories_id =185 or p2c.categories_id =186 or p2c.categories_id =187 or p2c.categories_id = 188 or p2c.categories_id =189 or p2c.categories_id =190 or p2c.categories_id =191 or p2c.categories_id =192 or p2c.categories_id =156 or p2c.categories_id =193 or p2c.categories_i d =194 or p2c.categories_id =195 or p2c.categories_id =196 or p2c.categories_id =197 or p2c.categories_id =164 or p2c.categories_id =167 or p2c.categories_id =168 or [url removed, login to view] s_id =169 or p2c.categories_id =170 or p2c.categories_id =171 or p2c.categories_id =172 or p2c.categories_id =173 or p2c.categories_id =174 or p2c.categories_id =175 or p2c.categories_id =176 or p2c.categories_id =177 or p2c.categories_id =178 or p2c.categories_id =769 or p2c.categories_id =179 or p2c.categories_id =181 or p2c.categories_id =182 or p2c.categories_id =183 or p2c.categories_id =2 or p2c.categories_id =18 or p2c.categories_id =198 or p2c.categories_id =199 or p2c.categories_id =19 or p2c.categories_id =20 or p2c.categories_id =148 or p2c.categories_id =149 or p2c.categories_id =200 or p2c.categories_id =201 or p2c.categories_id =202 or p2c.categories_id =203 or p2c.categories_id =204 or p2c.categories_id =150 or p2c.categories_id =151 or p2c.categories_id =205 or p2c.categories_id =206 or p2c.categories_id =207 or p2c.categories_id =152 or p2c.categories_id =153 or p2c.categories_id =154 or p2c.categories_id =155 or p2c.categories_id =208 or p2c.categories_id =209 or p2c.categories_id =3 or p2c.categories_id =775 or p2c.categories_id =776 or p2c.categories_id =812 or p2c.categories_id =817 or p2c.categories_id =821 or p2c.categories_id =21 or p2c.categories_id =141 or p2c.categories_id =259 or p2c.

Beceriler: Zen Cart

Daha fazlasını görün: zencart mysql slow, i.s.d. 191, zencart mysql slow queries, p sql, manufacturers supplier, sql queries, null, ion, fix slow, fix mysql query, 204, fix query, sql select select, sql select, queries sql, sql script mysql, slow queries, mysql query slow, 175, select query sql cart, server sql, zen cart slow mysql, mysql slow queries, zencart products, mysql slow

İşveren Hakkında:
( 0 değerlendirme ) Shanghai, China

Proje NO: #728956

5 freelancer bu iş için ortalamada 146$ teklif veriyor

XDREAM10

Dear sir, Please check your PMB. Thank you.

in 5 gün içinde150$ USD
(0 Değerlendirme)
0.0
pawanDeveloper

Hi, This is not a complex for us. We will take approx 4-5 days to optimize your complex mysql queries. Thanks, Ravendra

in 4 gün içinde30$ USD
(0 Değerlendirme)
0.0
topapp

Plz check PMB.

in 2 gün içinde100$ USD
(0 Değerlendirme)
0.0
ideawork1

We can do this project for $199 and in 10 days time. Please go through PMB for detailed proposal.

in 10 gün içinde199$ USD
(0 Değerlendirme)
0.0
globalsuhanasoft

Hello, please check PMB.

in 3 gün içinde250$ USD
(0 Değerlendirme)
0.0