LeafDB.app.sp_CalculatePatientCounts dies before it completes

[artgoldberg]

Our clinical data warehouse at Mount Sinai will be updated nightly. We'd like LeafDB.app.sp_CalculatePatientCounts to run to completion every night, so the counts are correct.

As we discussed, @ndobb , LeafDB.app.sp_CalculatePatientCounts recomputes the oldest counts first, so will eventually recompute all of them, perhaps over some days or weeks. But this won't be very effective when the clinical data are updated nightly (in our case, with millions of records per day) because the counts for the most frequently updated concepts may become wrong faster then they'll be updated.