Peruttu

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, 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 freelancers are bidding on average $98 for this job

techwelfare

Hi Let's clarify the requirement in details also if you want us to share our previous work let us [url removed, login to view] 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)
6.9
shihan033010

A proposal has not yet been provided

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

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)
5.5
25 $ USD 1 päivässä
(21 arvostelua)
5.2
point5nyble

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)
5.1
rameshweb212

Hi, I am top rated freelancer on [url removed, login to view] and making my profile here on [url removed, login to view] 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)
4.2
30 $ USD 1 päivässä
(4 arvostelua)
3.2
55 $ USD 1 päivässä
(1 arvostelu)
0.8
55 $ USD 10 päivässä
(0 arvostelua)
0.0
arindamkumar

A proposal has not yet been provided

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