Database layout tagging system
        Posted  
        
            by Kurresmack
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by Kurresmack
        
        
        
        Published on 2010-03-19T18:21:13Z
        Indexed on 
            2010/03/19
            18:31 UTC
        
        
        Read the original article
        Hit count: 345
        
I am creating a web site for a customer and they want to be able to create articles. My idea is to tag them so I am going to implement the system.
What is the best design, both from an architectural and a perfomance perspective:
1. To have table with all tags and then have a one to many relationship table that links a tag like this:
articles table with ID
tags table  with ID
one to many table with columns Article.ID and Tags.ID
2. To have one table with articles and one with tags for articles like this:
articles table with ID
tags table with Article.ID and tag text
Thanks in advance!
© Stack Overflow or respective owner