aopenshaw
Posts: 1
|
| Posted: 08/16/2010, 12:48 PM |
|
I have a grid that references a MySQL database. The page refreshes every 120 sec in order for users to see the latest data. My question is if a user submits an update during this interval how can I alert another user that the data in his view is not current?
|
 |
 |
datadoit
|
| Posted: 08/16/2010, 1:10 PM |
|
Technically it's feasible by creating some log fields for your data
table, such as:
insert_id
insert_datetime
update_id
update_datetime
Then query these fields as necessary and check against a session
variable that's holding the user's time of entry. AJAX would be the
preferred behind-the-scene method of doing the query every x seconds.
However, depending on the number of simultaneous users you expect in
this grid or page at any given time, and the frequency that you would
invoke the AJAX, you could be looking at a tremendous demand on your
processors, bandwidth, database locks and connections, etc.
|
|
|
|
|
