MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Brian Moon Date:June 23 1999 8:57pm
Subject:Re: Yellow Page Setup
View as plain text  
The only time this becomes a headache is when you have to search across
tables.  Without unions, you will have to do separate queries for each table
and then put the results together at the end.

Brian Moon
-------------------------------------------------------------------------
Phorum Dev Team - http://www.phorum.org
Making better forums with PHP
-------------------------------------------------------------------------


----- Original Message -----
From: Sasha Pachev <sasha@stripped>
To: Sean Hynes <newsletter@stripped>
Cc: <mysql@stripped>
Sent: Wednesday, June 23, 1999 6:36 AM
Subject: Re: Yellow Page Setup


> 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)
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread5745@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
>
>

Thread
Export to text?Robert Pruitt23 Jun
  • Yellow Page SetupSean Hynes23 Jun
    • Re: Yellow Page SetupSasha Pachev23 Jun
      • Re: Yellow Page SetupErik Liljencrantz23 Jun
        • Re: Yellow Page SetupSean Hynes24 Jun
      • Re: Yellow Page SetupSasha Pachev24 Jun
    • Re: Yellow Page SetupBrian Moon24 Jun
Re: Export to text?Kevin Smith23 Jun