Hi,
I am looking for someone pro-efficient! to optimize an existing MySQL database. The software is simple (not launched yet) and the database isn’t complicated, however:
There are 6000+ ID’s with about 20 properties. The properties are gathered every minute and the database grows to 900.000.000 records every month. And should be kept for at least 12 months (search in a database with 12.000.000.000 records! Quickly!)
At the moment displaying a data chart takes 20 seconds, the previous (deprecated) version took only 2-3 seconds and we wanted to make it 1 sec.
Yes, it is possible, the problem is that this new database is not well designed and not indexed properly.
Whoever bids to this project needs to know all about database indexing and database normalization. In addition an intuitive brain is needed to figure out the best architecture.
The task is simple but it is impossible to do without experience on this field, a normal PHP/MySQL programmer will fail, we need someone who really understands how MySQL works.
Thank you!
