Tech Tip: Best practice for eHealth ASCII DB load

Document created by Darshan_Desai Employee on Aug 8, 2014Last modified by SamCreek on Dec 17, 2016
Version 4Show Document
  • View in full screen mode

In order to expedite the ASCII load we suggest the following.

 

Stop eH services, stop Httpd services, stop database then, start the database only (no eH services) and run ASCII save. This approach will reduce the temporary database objects, clean up the AQs and improve the load performance.

 

In addition to the above information; If you stop eHealth and the Web before taking the save, this will reduce the temporary database objects and clean up the AQs. By doing so you will subsequently improve DB load times when that particular save is loaded.

Attachments

    Outcomes