Why CSV import is slow?

AI generated answer (using internal Slack threads):

CSV import in NetSuite can be slow due to several reasons: 1. Server-Side Scripts and Workflows: If the "Run Server Side Scripts" and "Run Workflows" options are enabled during the CSV import, it can significantly slow down the process. These options trigger scripts and workflows for each record being imported, which can be time-consuming. It's recommended to disable these options during the import process if they are not necessary. 2. Volume of Data: The number of records being imported at once can also affect the speed of the import. Large volumes of data can take longer to process. Breaking down the data into smaller chunks can help improve the speed. 3. Complexity of Data: If the data being imported is complex, such as transactions with hundreds or thousands of lines, it can slow down the import process. Simplifying the data or breaking it down into smaller pieces can help. 4. Lack of Multithreading: Multithreading can significantly speed up CSV imports by utilizing multiple processors. However, this feature is part of SuiteCloud Plus, which is an additional licensing option. 5. Environment: The speed of CSV imports can also be affected by the environment. For example, imports in the Sandbox environment can be slower than in the Production environment. 6. Database Migration: Some users have reported a significant drop in CSV import speed after the OCI database migration. This could be due to the new environment being slower. To speed up CSV imports, you can consider options like turning off server-side scripts and workflows, breaking down large volumes of data, simplifying complex data, and considering additional licensing options like SuiteCloud Plus for multithreading. Also, using third-party integrators like Celigo or Boomi or custom-built integrations can help improve the speed. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******