Refreshing display of grid every 1 second

  • Thread starter Thread starter Avi
  • Start date Start date
A

Avi

Hi Experts,

I would like to display the latest 500 events from a table which contains
over a million records. The speed of insertion is about 25 a second. How
can I display it and refresh the view every second to include the new 25 or
so events + the 475 out of 500 events from before.



What is the best method of so.



Thanks,

Avi
 
Avi said:
Hi Experts,

I would like to display the latest 500 events from a table which contains
over a million records. The speed of insertion is about 25 a second. How
can I display it and refresh the view every second to include the new 25 or
so events + the 475 out of 500 events from before.



What is the best method of so.



Thanks,

Avi
Click to expand...
You could update the grid on a timer.
However, if you update once a second, there is no way you could display
500 rows in a grid on the one screen and each second they would be reset
so you might want to revise the 500 down to 50-100 or so.

Just retrieve the last x records and rebind the grid each second.

JB
 
Back
Top