Sean Hynes wrote:
>
> Hello,
>
> I am creating a Yellow Page system for many cities. I don't have a lot of
> mysql experience so some pointers would be much appreciated.
>
> Lets say there are 500 cities and there will be 100 listings per city.
> Is it better to have one table with all entries , searchable by category or
> is it better to have a table for each city?
>
I would prefer separate tables. Even if you do not have a lot of data,
and can get decent perfomance by putting everying into one table, having
to deal with several tables will make you design/code a better scalable
application .
--
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)
