"Parent Child" Macro Runtime
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I am trying to find a way to reduce run time for my Bill of Materials macro (currently a couple days) with a data set around 290000 records. Currently I have to run each parent through individually to find levels of children. Keep in mind that additional parents can be noticed through 4 levels. Here is my current process. Thoughts?
- Labels:
- Batch Macro
- Iterative Macro
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @jeffgordon,
This yxmc looks like a candidate for an iterative macro nested within a batch macro. I drafted an idea of this the best I could without access to the data. I believe it encapsulates all the tools you were using within your macro in a slightly more efficient format. I'm pretty sure this will improve your runtime, although it will make it more difficult to troubleshoot. You'll probably need to do some adjusting before actually using this workflow since I didn't actually run it. Depending on how many iterations you want it to do, you might need to add in a maximum number of iterations on a filter or something.
Other options for reducing runtime can include reducing data sizes, like doubles into floats and autofielding strings.