Closed

MYSQL resolve slow queries

This project was awarded to SeniorPerlDev for $21 USD / hour.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$15 - $25 USD / hour
Total Bids
15
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: [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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online