Quickest/most efficient way to find the latest datetime indexed record

    Date: 09/07/06 (MySQL Communtiy)    Keywords: no keywords

    Is there a quick way of find the latest record if the field set includes a datetime field.  I am not going by the assumption that the latest will be the last auto. num. ID in the table.  My other thought was since I am taking a hit by accessing the DB, I might as well just add the latest record ID to the applications equivalent of a registry.

    Source: http://community.livejournal.com/mysql/102685.html

« Freeware search || SELECT DISTINCT first... »


antivirus | apache | asp | blogging | browser | bugtracking | cms | crm | css | database | ebay | ecommerce | google | hosting | html | java | jsp | linux | microsoft | mysql | offshore | offshoring | oscommerce | php | postgresql | programming | rss | security | seo | shopping | software | spam | spyware | sql | technology | templates | tracker | virus | web | xml | yahoo | home