What is the best way to present data that are updated quite frequently ?
I have 1.8millions rows. Some of them got updated everyday (around 100 - 300 updates daily).
Should I use cached map service or not ?
If I use cache, do all data got updated, or partially (just the updates only) ?
Do you have a date field to capture changes which would make this easier to query out the features? How would you account for deleted features?
Hi @MichaelVolz ,
Hardly any deletes. Most of the time are inserts and attribute updates. There is a date column that shows when the data were input.
The main problem is that these data *have to be shown* in its entirety. I have no idea yet to answer this challenge.