AnsweredAssumed Answered

Performance of VB.net to traverse is very bad , worse than the same code in VBA, how to improve?

Question asked by Vincent Li on Oct 26, 2018
Latest reply on Oct 26, 2018 by Vincent Li

Hey Guys,

As the topic mentioned, when I used the VB.net code to traverse the assembly design tree for all components on a 309-components assembly, it took around 36 seconds to finish, however, it is very fast on VBA, just like a flash.

Just don't know why, and I want to improve it on VB.NET , cause there is a project I have to use VB.NET.

I attached the demo video and samples with source code to it, hope any one could give some advice.

 

2018-10-26_15-05-21.png

 

Thank you.

Vincent

Attachments

Outcomes