[thelist] RE: mysql/php - creating an index

[Dunstan Orchard]

> >I'd like to be able to show a list of everyone <cited>'d in my blog and
> >links to the posts in which their name appeared.
> >... 
> >This table would be emptied and rebuilt each time I added/edited/deleted a
> >post.
> 
> I think you'll be much better off with two tables. One for the people cited
> and another one for the articles. That way you can also maintain a 
> list of who has been cited in which documents.

So, you're just suggesting I add in a middle table to link the cited person's 
name and the news post they appear in, rather than do it all in one table.

Would this be more efficient and faster database wise?

---------------------------
Dorset, England
http://www.1976design.com/
http://www.orchard.it/
http://www.maccaws.org/