Đang Thực Hiện

8755 MySQL Optimistations needed

Hi We need some more My SQL optimisations with our website: [url removed, login to view] We had some optimisations done before, but these were not sufficient according to our host. The problems are: - too many calls to the server - too many connections ot the server, some taking over 70 minutes We can't build a new DB, just eliminate these call-intesive parts of the site. Must be done quickly before our account is disabled! Here is a summary: | 248348 | mobile | localhost | mobiledb | Query | 1 | Sending data | | select product_review.heading_id ,product_review.review_heading_value from product_review | | 248578 | mobile | localhost | mobiledb | Sleep | 0 | | | | 248776 | mobile | localhost | mobiledb | Query | 0 | Sending data | | select product_review.heading_id ,product_review.review_heading_value from product_review | | 248999 | mobile | localhost | mobiledb | Query | 1 | Sending data | | select product_review.heading_id ,product_review.review_heading_value from product_review | | 249157 | mobile | localhost | mobiledb | Query | 1 | Sending data | | select product_review.heading_id ,product_review.review_heading_value from product_review | | 249581 | mobile | localhost | mobiledb | Query | 1 | Sending data | | select product_review.heading_id ,product_review.review_heading_value from product_review | | 249894 | mobile | localhost | mobiledb | Query | 1 | Sending data | | select product_review.heading_id ,product_review.review_heading_value from product_review |

Kỹ năng: Bất kì công việc gì, ASP, MySQL, SQL, Quản trị hệ thống, An ninh Web

Xem thêm: build mysql query, sql needed website, sending data site, build mobile asp website, mobile mysql, build mobile website mysql, mobile website mysql, sql build admin, taking calls, mysql account, asp mobile site, mysql mobile, parts admin, select select mysql, mysql select, mysql host, localhost, call system admin, mysql system call, build mysql, query mysql, asp query, asp mysql query, mysql asp query problems

Về Bên Thuê:
( 30 nhận xét )

Mã Dự Án: #1759622

Đã trao cho:

fusiontksl

Optimization is a kind of work that can be done at many levels...this bid is to check your database for things like key inconsistencies and slow datatypes and repair them, and to look over the script itself to consult Thêm

$20 USD trong 0 ngày
(0 Đánh Giá)
0.0