database simple performance question

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…
database simple performance question

See original post by schlogo

Leave a Reply