Export from NetSuite Saved Search to an FTP Server Performance

[raulbernales]

Good day. I'm trying to improve the performance of a flow where data source is coming from a NetSuite saved search that produces over 700,000+ rows and the destion tile is to an FTP server. The flow is taking more than 4 hours to transfer the data to the FTP server.

I tried increasing the Page size to 10,000 but don't see any huge improvement on the performance.

The thing is... It only takes me less than 10 mins if I run the saved search manually in NetSuite; export the result in CSV file; and drop it manually to the FTP server.

Are there any option that we can set to improve the performance? Any advice will be much appreciated.

[kathyanaqueeman]

Hi @raulbernales,

I am moving this post to our Troubleshoot custom flows section for more visibility.

Thanks!

[raulbernales]

I've tried recreating the flow and used "SuiteApp SuiteScript 2.x" and checked off "Do not store retry data". Result was from 9 hrs down to 6 hrs. This is still not good as I haven't included 5 more currencies.