Skip to main content

Reducing Overloaded Assemblies / BOMs

Tips for managing large assemblies and BOMs in PTC Creo Parametric to improve performance and data quality.

Identifying Overloaded Assemblies​

Signs your assembly may be overloaded:

  • Creo takes more than 60 seconds to open the assembly
  • BOM export produces more than 5000 rows
  • Excel becomes sluggish when working with exported data
  • Creo regeneration times exceed 30 seconds

Simplification Strategies​

Use Simplified Representations​

Create simplified reps that exclude non-essential components for BOM work. This reduces memory usage and export time.

Break Into Sub-Assemblies​

If a single assembly has 2000+ components, consider restructuring into logical sub-assemblies that can be processed independently.

Exclude Non-BOM Components​

Use Creo's component properties to mark items as non-BOM (fasteners, reference geometry, etc.) so they're excluded from exports.

BOM Optimization​

  • Filter by level: Export only top-level or specific depth levels rather than full recursive BOMs
  • Parameter pruning: Only export parameters you actually need — every extra parameter multiplies processing time
  • Template worksheets: Pre-configure your Excel template to only include relevant columns

Performance Monitoring​

Track these metrics to catch problems early:

  • Export time per 100 components (target: under 5 seconds)
  • Excel file size after export (warning: over 10MB)
  • Creo memory usage during export (warning: over 4GB)

Best Practices​

  1. Always work with simplified representations for BOM operations
  2. Export incrementally rather than full-assembly every time
  3. Archive old BOM exports rather than keeping them in the active workbook
  4. Use Power Query to consolidate data from multiple sub-assembly exports