www.webdeveloper.com
Results 1 to 3 of 3

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

  1. #1
    Join Date
    Dec 2005
    Posts
    25

    Efficient "Viewed" and "Unviwed" Tracking System

    Y'ello.

    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,
    arch.

  2. #2
    Join Date
    May 2004
    Location
    Manhattan NY
    Posts
    6,028
    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
    Posts
    25
    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



Recent Articles