Author Topic: Benchmarking getting formulas in bulk vs one-by-one  (Read 502 times)

0 Members and 1 Guest are viewing this topic.

Visisthebest

  • Sr. Member
  • ****
  • Posts: 389
Benchmarking getting formulas in bulk vs one-by-one
« on: December 29, 2020, 06:16:08 AM »
Old blog post benchmarking VSTO and Exes getting formulas in bulk or one-by-one:
https://surrogate-tm.github.io/wmorein/2007/11/13/solution-performance-tip-1-getformulas-and-setformulas.htm

Amazed how slow out-of-process executables are 😱

Also noticeable how Visio’s many-shapes slowdown becomes a much bigger issue with 1000 versus 100 shapes, as using GetFormulas (bulk) still delivers much better performance with VSTO 1000 shapes, but not as spectacular a difference as with 100 shapes.

PC from 2007 or earlier, so I wonder how much better is the performance is on a cheap AMD Ryzen 4000 notebook today (or a more expensive Tiger Lake notebook), although I understand older Visio versions may have done things much faster. Why did newer version of Visio slow down so much?
« Last Edit: December 29, 2020, 06:21:47 AM by Visisthebest »
Visio 2021 Professional


Visisthebest

  • Sr. Member
  • ****
  • Posts: 389
Re: Benchmarking getting formulas in bulk vs one-by-one
« Reply #2 on: December 29, 2020, 11:36:47 AM »
Personally I think Visio 2019 is fine below 1000 shapes, although rendering shapes with gradients in a 500+ diagram could also be faster.

I saw a Microsoft presentation about Visio 2019 where they said they improved diagram rendering performance compared to Visio 2016, I think it was at Ignite when they presented 2019.
Visio 2021 Professional