Company report module query speed are not goozyet, recently want to big change, the main condition is:
1, now use the database is MySQL
2, the table is more, little five tables, many ten table
3, the field generally within 30
4, schedule of the contract, the order details such as the main business table data has 500 w +
5, allowed to ask the next day, no request to query the data, of course, the best is the real time the better


Because don't know much about the large amount of data of the tool, want to ask next, what is the solution to recommend