optimizing mysql

This project was awarded to boygiandi for $100 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
Total Bids
Project Description

We have two tables in mysql database([url removed, login to view]). One table has 300 records another table (myisam) has 50 millions records. We will provide you three queries with seven filter condition and 5 order by. We like to optimize those three queries, so that when we add different combination of filter conditions or all filter conditions and different order by, we need to expect the result by 250 msec. Our server has 4 cpu and 4 GB RAM. We also provide you the conf file. When we provide the data, we will provide for 8millions records and you need to make it into 50 millions records.

Deliveries: 50 million records table, different combination of three queries, filters and order by with performance timing. We will also test that and ensure we meet the performance.

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