This project was awarded to boygiandi for $100 USD.Get free quotes for a project like this
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.
Browse Related Skills
Other things people do on Freelancer
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