Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Register now
Better Practice: Scheduled Script or Workflow
Hey All,
I was hoping someone could lend their expertise to this question I have been mulling over. I know there are some obvious trade-offs to these two, but I just don't know what effects we will incur on our system which is currently on a shared server.
So, we have about 10k products in our instance for which we receive contract/promotional pricing over EDI. We currently have a scheduled script of about 1000 lines of code that essentially does a search of all these custom records that get created in our system and then applies these prices to the items on a daily basis. The script usually takes about 8 retries to completely finish which can take 30 deployments in about 2 hours time to complete. As a software engineer who didn't know much about the requirements, my initial reaction was just refactor this beast and optimize