Closed

BigTable MySQL Optimisation - consultancy services

We have one datatable of 28 million (28,000,000) of records and each day growth on 350 thousand records (350,000) and we are sure that this insertions quantity goin to be constant.

In the future, we going to change the data base (hipertable, cassandra, mongoDb, etc), but now we need to kep for 3 month more with MySQL. Then need to implement some solution for improve the response-time when ned to excute some query-reports.

the 350,000 insert each days, is by JAVA programs directly to mySQL.

!!! See the ppt attachment, inside have the table estructure and the query and the response-time for this query.

We hope from the contractor, provide us the ideal recipe for improve only 2 query-reports, without impact the response-time of insert process of new records.

milestone-1: impact of the 1ts recipe, we pay 25%

milestone-2: impact of the 2nd recipe, we pay 25%

milestone-2: impact of the 3nd recipe, we pay 50%

We don't have development environment (then dont server for tests), we can't give access to this server, we will make available for execute server commands (but each command we revise and calcale the riksk for to evite any exposu to loss data)

This important always rememb that this, will be the unique way to work.

Skills: Database Administration, Database Programming, MySQL

See more: sql server reporting services work, seo work process, spanco marketing consultancy services, mysql index optimization, mysql query optimization and performance tuning, mysql query optimization tips and tricks, improve mysql performance large database, mysql optimization techniques, query optimization in mysql with example, mysql optimize table performance, speed up mysql queries large tables, telemarketing services work commission, empower consultancy services hydrabad, pbx tata consultancy services brasil, extracting data mysql via web services, imaging consultancy services limited, danish english translation services work, mysql sql integration services, bakkiam consultancy services, apices consultancy services pvt ltd

About the Employer:
( 4 reviews ) Lima, Peru

Project ID: #18805713

8 freelancers are bidding on average $218 for this job

KashirinA

Hello. How are you. I have read your description carefully. Very Interesting. I have many experiences in servier side, user side processing big datatable and optimizition. So I can fix your problem and I can impro More

$155 USD in 3 days
(55 Reviews)
6.5
vinaysinghh

I am MySQL database expert having more the 8 yrs of experience and done more then 100 projects on MySQL performance tunning

$222 USD in 1 day
(56 Reviews)
5.3
saubhagyamweb

Hello, We're SAUBHAGYAM, a Web and Mobile App development company based in India. Portfolio: [login to view URL] We've industry proven expertise in developing trendy, innovative website and mobile app for I More

$250 USD in 30 days
(1 Review)
3.5
tahirbaig86

Having vast expereince in optimization and development in MySQL database in PROD , DEV and Test environemnts.

$222 USD in 5 days
(0 Reviews)
0.0
kaviwije

Hi, I'm currently working as a software engineer with having more than four years experience with working mysql schema, stored procedures and indexes. And also have experience with a large data set which is growing More

$222 USD in 3 days
(0 Reviews)
0.0
JuanitoValeroso

Más de dos años de experiencia en optimización de consultas y procesos masivos de base de datos Oracle y MySQL.

$222 USD in 10 days
(0 Reviews)
0.0
balliengg44

Hi, I am Bahubali from Pune India, I am a Full stack JAVA developer with experience of 6 years in JAVA and related technologies. Please let me know more details about your project.

$200 USD in 3 days
(0 Reviews)
0.0
gladrich

Hi If it is issue with one table for [login to view URL] can archive the old data in replica of that [login to view URL] you can reduce the number of rows in live [login to view URL] that case report needs to be modified to fetch the recor More

$250 USD in 3 days
(0 Reviews)
0.0