MYSQL resolve slow queries

IN PROGRESS
Bids
15
Avg Bid (USD)
$20 / hr
Project Budget (USD)
$15 - $25 / hr

Project Description:
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.

Hours of work: Unspecified Project Duration: < 1 week Skills required:
AJAX, jQuery / Prototype, MySQL, PHP
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$30 / hr
Hours: 10 hr/ week
$22 / hr
Hours: 50 hr/ week
$20 / hr
Hours: 10 hr/ week
$15 / hr
Hours: 20 hr/ week
$20 / hr
Hours: 3 hr/ week
Hire aoefmpes
$16 / hr
Hours: 3 hr/ week
$16 / hr
Hours: 2 hr/ week
$38 / hr
Hours: 2 hr/ week
Hire SeniorPerlDev
$21 / hr
Hours: 15 hr/ week
Hire sisyphus2006
$22 / hr
Hours: 24 hr/ week