Map Service publishing with a lot of new data

[yockee]

Hi,

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) ?

Thanks

[MichaelVolz]

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?

[yockee]

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.

Thanks