Improving Product Library Performance

Improving Product Library Performance

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 article. 



    • Related Articles

    • Formulas

      Formulas are used extensively throughout Microvellum. Formulas drive the library products and are used to help automate procedures. Formula reading and writing can be a challenge. Luckily, reading and writing formulas doesn’t require a degree in ...
    • Overview: Formula Driven Materials

      There are two distinct types of Microvellum materials – formula materials and non-formula (traditional) materials. This article focuses on formula-driven materials. Accessing Formula-Driven Materials You may use either the Add Formula Material ...
    • Issue: Errors & Slow Performance of Microvellum OEM or AutoCAD

      When using AutoCAD, you may notice errors, slow performance, or sometimes, the application may crash. The Windows "Page File" size may cause this. This article presents the optimal setting for this file when using Microvellum OEM, or Microvellum with ...
    • Using Formula Editor

      The Formula Editor is a handy tool for reading and writing formulas. To access the Formula Editor, select a cell and press the F2 key. Large Text – Checking the box will make all the text larger. Find and Replace – Launches the find and replace. Name ...
    • Issue: Slow Performance & Crashes Associated with Antivirus & Firewall

      Microvellum and AutoCAD To minimize performance issues and crashes associated with antivirus software, we advise the following steps. Exclude these Microvellum folders:  C:\Program Files\Microvellum C:\Users\<username>\AppData\Roaming\Microvellum ...
    • Recent Articles

    • Toolbox Release Notes | Build 23.1.0921.641

      The following release notes apply to Toolbox build 23.1.0921.641 Cumulative Library Updates Fix Figure 1: Cumulative Update issue. There was a bug noted by users while attempting to download the Foundation Library’s phase 1 cumulative update and ...
    • Microvellum Foundation Library Release Notes | Build 23.0919

      Additions Added new product Master Double Sided Cabinet. Added “Horizontal Handles Centered” global option to all doors. This is available for all tab pulls, handles, and knobs. Added a new DRAWRECTANGLE 2D plan token to the door subassemblies. This ...
    • My Cases: Case Details

      Once you've logged into the Client Portal and navigated to the My Cases area, simply click on the case title to access the case details page. Here, you can thoroughly review the case description, append additional comments, upload attachments, and ...
    • My Cases: Overview

      Once you've logged into the Client Portal, accessing your support cases is a breeze. You can simply click on the "My Cases" icon in the flyout menu or choose the "View Cases" button conveniently placed on the Welcome page. Inside this section, you'll ...
    • Uploading Attachments to Support Cases

      Support case attachments are files or documents attached to a support case or ticket, serving the purpose of providing additional information, context, or evidence relevant to the reported issue. These attachments can encompass a wide range of file ...