I try to find the optimal database design for my mysql/ php/ [url removed, login to view] project. It is a MySQL database with a PHP app that allows queries to the database and reports the results in [url removed, login to view] charts.
The set-up looks like this today:
290 municipalities divided into 25 counties
1 st mysql database
6 tables with various data (10 000 lines for each municipality in each table)
7 pieces of columns in tables
2.9 million lines of data in each table
I need a fast database that is could run all kinds of queries without long responstimes.