MYSQL resolve slow queries - repost
This project received 7 bids from talented freelancers with an average bid price of $20 USD / hour.Get free quotes for a project like this
Project Budget$15-$25 USD / hour
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: [url removed, login to view] Lock_time: [url removed, login to view] 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.
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online