7 Excel memory usage can become fragmented with each SmartView retrieve and Excel tends to hold memory that it no longer is using If a computer is found to be paging during a refresh and more than three refreshes have been performed since initiating the Excel session: - Shut down Excel - Wait before restarting Excel, as it can take Excel up to 15 minutes to release memory - Restarting the entire computer will also release memory.
{"Image DocumentName": "Tip #2 \u2013 Optimal PC Memory usage", "Image ImageDescription": "Examine memory usage of the PC while running a retrieve. Performance will start to decline if the \u2018Total Commit Charge (K)\u2019 is larger than the \u2018Total Physical Memory\u2019, as the PC will have to page memory to disk. The steps to determine this are: Depress the \u2018Ctrl\u2019 \u2018Alt\u2019 and \u2018Del\u2019 keys. Choose \u2018Task Manager\u2019 Compare the \u2018Total Commit Charge (K)\u2019 with the \u2018Total Physical Memory (K)\u2019. In this example there is total memory, with only Committed, so there are. not any paging issues here.", "Image XResolution": "37", "Image YResolution": "37", "Image ResolutionUnit": "Pixels/Centimeter", "Image Software": "SlidePlayer", "Image YCbCrPositioning": "Centered"}