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.



0 Comments:
Post a Comment
Links to this post:
Create a Link
<< Home