On Tuesday 22 April 2008 05:29:54 Tedit kap wrote: > Question: I am building a site that is mainly a news portal site about > several categories of a specific subject... There will be other elements > too but it will be mainly a news portal site. What makes more sense - to > create separate databases for each category and then build news and > othertables under each db, or can I just use one db and build many tables > under it, news tables for each category, and other tables for each > category. In the long run, what makes more sense? As far as backing up, > updating data, add more tables in time, writing php to pull data, other > aspects i can not thinnk of...Any advice? This is the first time I am > creating dtabases so I am having hard time to see the long term...I mean, > medium size or big newsportal websites for example, how would they do, with > a lot of different databases and few tables under, or with few databases > with many tables under? Thanks > > >
One database, and only a few tables. As I see it you only need two tables for the news portal, as you want it. One table for the categories, and one for the news and you connect it by the id from the category table. You don't need "news tables for each category". This way you can always add a new category easily, by adding a new record to the category table. regards mmlado
