MEDITECH DR, NPR, MEDITECH Reporting, MEDITECH Reports, MEDITECH DR Reports, MEDITECH BI, MEDITECH Data Repository
I'm your host, John Sharpe, a MEDITECH Report Writing Consultant living in Spokane, WA. Read more ...
Expand your network by connecting on these social media sites:
Sign up for the MEDITECH Reports Blog; details to attend MEDITECH workshops are sent out 1 week in advance to all MEDITECH Report blog subscribers.These MEDITECH Workshops are sponsored by Donna Carroll at the MEDITECH Community Bulletin
Ascii Table: For NPR Report Writer Loop Builder: For NPR Macros Key Codes: For CDS Attributes List Builder: For NPR Macros MT Report Names: For NPR Reports MT Structure Viewer: For Physicals Strings: Format & Sort
Current Articles | RSS Feed
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.
Want an alert when the next post is published? Click the phone and Subscribe to the MEDITECH Reports Blog!
Allowed tags: <a> link, <b> bold, <i> italics
I'm your host, John Sharpe, a MEDITECH Report Writing Consultant living in Spokane, WA. Read more ...