MySQL Forums
Forum List  »  General

Re: Stepping through records
Posted by: Peter Brawley
Date: July 16, 2013 11:19AM

> we have a database ...

You mean a table, don't you?

You want the displayed page to refresh each time the user selects a different row? What if the the user does not change rows, but the selected row changes whilst she's looking at it?

Up-to-the-second aggregate stats are costly. You will have to decide how much out-of-dateness can be tolerated---one sec, 10 secs, one minute, &c---then write a refresh procedure which runs that often. A last_update_time column can make such a procedure less costly.



Edited 1 time(s). Last edit at 07/20/2013 10:03PM by Peter Brawley.

Options: ReplyQuote


Subject
Written By
Posted
July 16, 2013 04:36AM
Re: Stepping through records
July 16, 2013 11:19AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.