The purpose of this article and video is to provide guidance on how to enhance the speed and performance of your Library.
When it comes to Library Performance, it refers to the speed at which products are rendered in 2D and 3D, as well as the speed of creating and processing work orders. There are multiple factors that can affect Library Performance, as the spreadsheets are a powerful tool and the sheer number of formulas and variables in one’s Library can take time for your computer to process. To help mitigate slow performance times multiple measures can be taken.
One of the first steps to improve performance is to clean up the formulas in the product spreadsheet. Hard values, represented by black text in a cell, are better for performance than cells with red text, which are calculated by formulas. Removing the equal sign or formula for any cell that does not need to be calculated will reduce the load on Microvellum, thus improving speeds. Additionally, when reviewing the spreadsheets, it's important to consider the use of custom functions. Custom functions can be useful for quickly calculating dimensions or names based on materials and variables, but they can also slow down performance. For example, the formula IFERROR(L!Side_Thickness_left,PARTTHICKNESSM(MVCP,M!MFSH,M!MFSO,M!MFBO,Left_Side_Name)), requires searching an external reference in M, which may involve thousands of rolls, and can slow down processing times. To improve performance, only use custom functions where necessary.
Deleting and exporting old Work Orders is another measure to take to improve the performance of Microvellum. To export Work Orders out of your Library, follow the instructions on the Deleting a Work Order