Best way to return a TimeStamp for if-modified-since ?

Discussion in 'Databases' started by Knuttenstein, Jul 29, 2009.

  1. #1
    Hallo, im looking for the best way to return a timestamp. In other words the easiest way to determine if something has been modified.

    Im currently doing it by getting the timestamp of the last post in my table. Im not sure if this is the fastest, or most performance friendly way of doing it.

    My select looks like
    SELECT TimeStamp FROM Forums WHERE TYPE = 'Forum' ORDER BY LTIME DESC LIMIT 1
    Code (markup):

     
    Knuttenstein, Jul 29, 2009 IP