Results 1 to 3 of 3

Thread: Efficient "Viewed" and "Unviwed" Tracking System

  1. #1
    Join Date
    Dec 2005

    Efficient "Viewed" and "Unviwed" Tracking System


    I'm looking to utilize an efficient method to store the IDs of viewed and unviewed posts. I figured it could easily be done by storing all of the IDs in a database containing the user records, but then I'm not sure if that's the most efficient and space-saving way to do it. Is there a better way to do it?

    (Does anyone know what kind of system bulletin board software like phpBB and Invision uses for their "read" and "unread" tracking?)

    Thanks in advance,

  2. #2
    Join Date
    May 2004
    Manhattan NY
    Well the post IDs would have to already be in the database. To do what you want, add another field to the table holding a boolean for viewed yes/no. Do you want to do this on a per user basis, or viewed/unviewed by anyone at all?

  3. #3
    Join Date
    Dec 2005
    Viewed/unviewed on a per user basis. I don't think I could do it any more efficient than having a field with the viewed IDs separated by a "|", though.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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