|
|
Posted by Captain Paralytic on 01/24/08 12:40
On 24 Jan, 12:26, Erwin Moller
<Since_humans_read_this_I_am_spammed_too_m...@spamyourself.com> wrote:
> Captain Paralytic wrote:
> > On 24 Jan, 09:39, Erwin Moller
> > <Since_humans_read_this_I_am_spammed_too_m...@spamyourself.com> wrote:
> >> Neeper wrote:
> >>> I'm creating an application for multiple cities (about 20-50 cities).
> >>> I'm not sure whether to use a single table to store for all cities'
> >>> items or break each one out into a seperate table for each city.
> >>> I know a seperate tables will be faster for searches because there
> >>> will be less records but in terms of maintenance it gets a little
> >>> messy and hectic as the list of cities will grow.
> >>> I guess it all comes down to is, the number of records I would have.
> >>> I'm not sure how many records it takes before MySQL starts to slow
> >>> down.
> >>> Please give me your thoughts.
> >> Hi,
>
> >> If the application is classified, as you wrote in your first post, you
> >> might also consider using different databases for each city, with
> >> different username/passwords.
> >> If you don't, you should make very sure city1 cannot access data for
> >> city2, eg by doing getname.php?cityid=2 or something like that.
>
> >> To your question, if you use an index on the relevant columns on the
> >> table, the queries are probably very fast, IF you use that indexed
> >> column in your where-clause.
>
> >> Regards,
> >> Erwin Moller
>
> >>> Thanks.
>
> > Whilst this subject has nothign to do with php, I think you have the
> > wrong idea about the context in which "classified" is being used.
>
> > It is calssified as in adverts being listed in categories (the
> > classes) rather than classified as in "top secret".
>
> Oh yes, you might be right. :-)
> Categorized might have been a clearer word.
>
> Erwin
True, but they are known as "classified ads", in both newspapers and
on things like ebay.
Navigation:
[Reply to this message]
|