If the extract runs at the same speed all of the time, use binary troubleshooting to divide & conquer the performance issues inherent in the code. Assuming the extract can be run faster when restarted, rule out slowness, 1 aspect at a time:
- Can the extract be scheduled to start at another time and run quicker? Example: 2:00 a.m. instead of 12:00 a.m. If so … start time could be the cause.
- Reboot the machine where the extract is running. If … extract run time does not improve, the state of the server was not the issue.
- Run the extract from another machine. If run time improves, look at re-installing MEDITECH client on the original machine. If performance does not improve, then try re-imaging the client machine.