AnsweredAssumed Answered

Boomi process that Queries Customer information from netsuite and loads into SQL database takes 24hrs for completion

Question asked by madhulika.ramabhotla069649 on Jul 11, 2018
Latest reply on Jul 16, 2018 by Sjaak Overgaauw

I created a Boomi process that Queries(QUERY ) Customer information from Netsuite and loads into SQL database.However my process takes nearly 22hours to complete as it queries 100000 records.I selected the batch option in Netsuite and SQL query operation.Can anyone tell me how to quickly complete this .Also what are the best practices when querying large data volumes for migration.I want my initial load to be completed quickly so that there after I can perform incremental load using SYNC FLAG/last modified date Adam Arrowsmith #Longrunningprocess large set of data netsuite query sql 

Outcomes