Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
karthur1
945 Views, 14 Replies

Is there a faster way?

I have a ilogic code that changes all my memebers lengths by a specific amount. The code is here in this thread.  The line that changes the member is 

 

i = iPart.FindRow(comp.Name, "Length", "=", oLength)

 

The problem that I have is that this iPart has a couple thousand rows (not exactly sure how many... I just know it a lot).  When the code runs, it will take over 6 minutes to change out two parts.  The CPU is running at 25-26% during this time, so its working hard at it. If I manually change the components, it will take the ipart table about 45 seconds to come up so I can change the part.

 

I take it that the code is actually running thru the table until it finds a match. Since the table is rather large, it takes awhile to scan thru it.

 

Is there a faster way to set the member?

 

Thanks,

Kirk