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
Total Bids
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.

Skills Required

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