>What are the circumstance when it is prudent to use double buffering and when perhpas not?

One doesn't generally "use" double buffering. Double buffering is a side effect of having a view and its underlying table(s) open in the same work area.