I am building a database to host about 5 million entries, each of these entries is divided up into different countries.
What is the best way to build and set up the database?
I can think of two ways,
1. Having a separate lookup table for the countries, then having all the entries with a country id and reference it. This would mean all entries are in one table…Would this be slow to run queries etc?
2.The other idea I had was having a different tables for each country so the entries are already in there current country. So each table would be England_entries , france_entries, spain_entries etc and then running queries that way?
Which way would be the best or is there a better way?
Many thanks in advance.
What is the best way to build and set up the database?
I can think of two ways,
1. Having a separate lookup table for the countries, then having all the entries with a country id and reference it. This would mean all entries are in one table…Would this be slow to run queries etc?
2.The other idea I had was having a different tables for each country so the entries are already in there current country. So each table would be England_entries , france_entries, spain_entries etc and then running queries that way?
Which way would be the best or is there a better way?
Many thanks in advance.