Re: optimization

[Roland Bouman]

I just wanted to add, this does not guarantee that you are getting the last entry in your table, it is only getting you the record wich has the largest value for the particular date column. In particular, if you did not take precautions against it, you can expect multiple records with all of these MAX solutions.

Note that in you LIMIT solution, you are guaranteed to get just one record, but there may be more records with the same value for the date column you ORDERed BY. In that case too, you are only guaranteed to get a record with the largest value for the date column, not The Last Entry.