without any data to compare against, I can't comment - perhaps the member only has one record so there is no previous one.
With regards time to run. As previously advised, ensure all fields that are used for sorting or criteria are indexed
without any data to compare against, I can't comment - perhaps the member only has one record so there is no previous one.
With regards time to run. As previously advised, ensure all fields that are used for sorting or criteria are indexed