database splitting; multiple tables
- by Ben
I am coding a classifieds ad web app.
What is the optimal way to structure the database for this?
Because of the high repeatability, would it be faster (in terms of searching/indexing) to have a separate table in the database for each city?
Or would it be okay to just have one table for every city (it would have a lot of rows..).
The…