SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Zealot ozonew4m's Avatar
    Join Date
    Apr 2006
    Location
    at my desk
    Posts
    136
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    tags system pre build advice

    Im building a content management system where the content will be quite large and of various types.. eg links, articles, blogs, q&a, gallery etc

    I would like to link the whole site together via a tags system so that on each page I could have related items from other sections of the site.

    what would be the best way to set this up to give me the best speed and accuracy when it comes to searching and pulling content via the tags?

    what is the best table type to use for most accurate search

    any and all advice appreciated please

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,014
    Mentioned
    53 Post(s)
    Tagged
    2 Thread(s)
    each of the entity types (links, articles, blogs, etc) will have its own table, right?

    each should therefore also have its own tag table, where each entity would have multiple rows, one per tag

    do not try to throw all the tag relationships into the same table
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •