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.
8 freelancers are bidding on average $218 for this job
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.