1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

database simple performance question

Discussion in 'MySQL' started by schlogo, Nov 21, 2013.

  1. #1
    Hello

    i need to build a database of people with thoses data

    name
    first name
    nation of birth
    date of birth
    city of birth
    region of birth
    country of birth

    nation of death
    date of death
    city of death
    region of deayth
    country of death


    it will hold record for 1000 people and be queried very often to check how many people originate from a country, are born a certain year etc...

    what is the best way to store country and regions to optimize the search. Should it be in this table stored as text or in another table , leaving only the city in this table ?

    tks
     
    schlogo, Nov 21, 2013 IP
  2. PoPSiCLe

    PoPSiCLe Illustrious Member

    Messages:
    4,623
    Likes Received:
    725
    Best Answers:
    152
    Trophy Points:
    470
    #2
    With only a 1000 entries, it really won't matter much, but create one table with cities, one for regions etc, and the have a main table where you reference these by id.
     
    PoPSiCLe, Nov 21, 2013 IP