Database design for a mysql database

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.

Taidot: Big Data Sales, Tietokantakehitys, MySQL, PHP

Näytä lisää: mysql calendar database design, database calendar design mysql, design database mysql olympic games, mysql design database, website design database, design database project using mysql, travel agency website design database asp, database report design programming expert required, mysql accounting database design, design database mysql private messaging, adult en streaming, addtion en asp, addition en visuel basic, activar breadcrumbs en virtuemart, action cron en magento, accordion panel ajax en vb net, accordion horizontal en flash as2, accordion en ajax, acajoom en virtuemart, abrir popups en joomla, aac en flash, 100reduction com en francais, php mysql website design database retail, bygg mallorca, mysql roster database design

Tietoa työnantajasta:
( 29 arvostelua ) Gällivare, Sweden

Projektin tunnus: #13097166

10 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hi Let's clarify the requirement in details also if you want us to share our previous work let us [login to view URL] have a few questions about your project, please send us message so that we can discuss more. Thanks & regar Lisää

$231 USD 7 päivässä
(142 arvostelua)

A proposal has not yet been provided

$222 USD 3 päivässä
(304 arvostelua)

Hi, I'd like to hear more details about your project. I've got 15+ years of experience in IT development, of which 10+years in web development using PHP/HTML/Javascript/AJAX/mySQL technologies. I worked in a b Lisää

$250 USD 10 päivässä
(28 arvostelua)
$25 USD 1 päivässä
(21 arvostelua)

Hello, I have been working with a MNC based company since last ~ 6 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in Lisää

$35 USD 1 päivässä
(33 arvostelua)

Hi, I am top rated freelancer on [login to view URL] and making my profile here on so I can work hard on your task and will not work just for earning. I have 10 years of professional experience and built more Lisää

$45 USD 1 päivässä
(18 arvostelua)
$30 USD 1 päivässä
(4 arvostelua)
$55 USD 1 päivässä
(1 arvostelu)
$55 USD 10 päivässä
(0 arvostelua)

A proposal has not yet been provided

$30 USD 1 päivässä
(0 arvostelua)