MEDITECH NPR Report Performance Improvement

NPR Report Performance Improvement Tips from a recent BAR Report:

1. Review the data definitions from page 1 on the report.

- BAR.PAT.discharge.x[bar.dis.ser,account]
?(B)BZDDX[bzds,bz]

- BAR.PAT.top[account]
$(B1)BZ[bz]

2. Order the subscripts from the index in the SELECTs first.

3. Remove report fragments that execute for every record.

Last week a client challenged me to improve the performance of a BAR report. I was able to reduce the run time of the report by about 75% using the steps above. While this is not an exhaustive list of improvements tips, it will make a good article in the future.

If you are looking for such a list, email me at: jsharpe@comstock-software.com; depending on interest, the list could come out sooner than later.