what is the maximum netsuite suiteql query execution time in map/reduce script's getInputData()?

AI generated answer (using internal Slack threads):

The maximum execution time for a NetSuite SuiteQL query in the getInputData() stage of a Map/Reduce script is 300 seconds. This is due to the governance limit set by NetSuite for this stage. If the script exceeds this limit, it will throw a

SSS_TIME_LIMIT_EXCEEDED

error. If you're experiencing long execution times, it's likely due to the size and complexity of your data. If your search results are large (e.g., 50,000 - 200,000 rows), the time taken for the getInputData stage can scale poorly. For example, 60,000 results may take much more than twice the time of 30,000 results. One way to improve performance is to limit the number of results in your search. For instance, limiting the results to 30,000 and running the Map/Reduce script multiple times as needed to process all of the data can result in a faster total run time. Another way to improve performance is to use SuiteQL for your search. However, the effectiveness of this approach may vary depending on the complexity of your query and the size of your data set. Remember to optimize your script to avoid exceeding the governance limit. For example, avoid loading or searching for each line individually while looping through the results. Instead, retrieve all the data needed for the lines at the same time. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******