Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
AdvancedSearch - THANK YOU!
Lots of new objects to deal with and learn about, a strange and counter-intuitive object model but holy crap is it faster!!
// New joined transaction search
Searching for PMD.NetSuite.SuiteTalk.TransactionSearchAdvancedrecords - elapsed time: 0.194738583037398
// Old method of loading a sales order, then loading a customer to get a custom field on a customer record (given a sales order Id only)
Loading salesOrder record - elapsed time: 14.6260125653901
Loading customer record - elapsed time: 3.26349148644949
DA method - elapsed time: 17.9001594516048
Almost 100X times faster.
From nearly 18 seconds to less than 1/4 of a second.
Awesome, thank you NetSuite for doing this.
Now we just need custom record joins and we should be in business.
Steve Klett | Senior Developer
NetValue Technology
0