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
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.