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.
9 freelancers are bidding on average $314 for this job
Hi, we are the team of professional designers, developers and SEO experts. We will provide you work with high quality and professional build themes. Please check private message for further details.
Datonil is an IT consulting 24*7 Onsite and Remote MySQL DBA services firm helping corporations,apply and use technology for successful and profitable business growth for their databases. [url removed, login to view]