On Tue, 2008-04-22 at 06:47 +0200, Mladen Milankovic wrote: > On Tuesday 22 April 2008 05:29:54 Tedit kap wrote: > 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
Careful with this approach, if your news website is VERY busy and you expect to add thousands of articles in a very short time, then you might want to create a table for every category as table size will be your enemy in a year or two (or even sooner). Getting information from 1 huge table will take considerably longer then retrieving information from multiple small tables. Plan a head, it will pay off.
