Originally Posted by markman641
I don't quite understand how those tables would work. How would i store the list of countries per offer in a country category? If you wanted a new row for each, that would be a LOT of rows. Give me an example of each table with a test row?
This is not a knock at you personally, but I'm always surprised that people get hung up on having a "lot" of rows.
The important thing is to normalize the data.
A lot of rows in a table is 50,000,000 and even then that isn't really a lot.
Properly tuned databases with good indexes for the type of queries being ran, with normalized data and optimized queries are important. The number of rows, significantly less important.