Closed

MYSQL resolve slow queries - repost

We have some slow mysql queries. One is caused by including queries from views.

Here the log info:

SELECT min(price) AS price_min, max(price) AS price_max FROM categories_price;

# Time: 130710 7:51:55

# User@Host: xxxxxx[xxxx] @ localhost []

# Query_time: 7.922020 Lock_time: 0.000157 Rows_sent: 1 Rows_examined: 14029050

The categories_price [2700 records] view combines an other view called products_price [2480 records].

I have try the 3 ALGORITHM; TEMPTABLE - MERGE - UNDEFINIED without success.

The others are only not correct coded queries that slows the result.

The code is written for our web-shops.

We need a professional MYSQL coder for this project as well for future projects.

Our rules when you get this project:

It is strictly forbidden to download other info/files as we will describe later.

Skills: Virtual Assistant

See more: slow queries, queries, mysql algorithm, virtual view, algorithm mysql, max assistant, virtual host, merge projects, mysql slow queries, mysql slow, merge algorithm, virtual assistant download, rules algorithm code, download virtual assistant, wordpress slow apache mysql, query_time lock_time, web queries, mysql views, vbulletin queries slow, virtual max, web shops, mysql merge, mysql host, algorithm projects, mysql slow view

About the Employer:
( 0 reviews ) Philippines

Project ID: #4711528

7 freelancers are bidding on average $20/hour for this job

oobretenov

I could help you with the bad query time.

$22 USD / hour
(0 Reviews)
0.0
smileitsolu

"This is not genric message we have properly read your project and intrested for that " we are a Team of professionals having good experience of various projects. I will really appreciate if you can share your query More

$20 USD / hour
(0 Reviews)
0.0
sisyphus2006

I have vast experience with MySql sites, please see my site [url removed, login to view]

$22 USD / hour
(0 Reviews)
0.0
rumonkhan068

I am expert this job.

$16 USD / hour
(0 Reviews)
0.0
prodiproy333

Dear Sir Your job post has caught my attention because and I’m very interested in your job post involving these skills. I have good experience in data entry, web research, Google documents and MS Office. My typing spe More

$16 USD / hour
(0 Reviews)
0.0
eztechsol

Can get this done for you. Plz see PM

$22 USD / hour
(0 Reviews)
0.0
elboukharimu

I can help you, please check your Inbox

$22 USD / hour
(0 Reviews)
0.0