Custom Script - Long Time Execution
I have a custom script which fetch contact data from CSV file and generates contact records with customization.
Rows in CSV file: 99500
Script includes: set_time_limit(0);
Issue: When i execute script from browser, script can generate only 4000 contact records per execution, however i have executed same script on different environment, at this time script generates 23000 records per script execution.
Is there any setting i need to change somewhere?
After looking at log message, it shows:
DB API Error SQL Fcn: execute() [SQLStatement.cpp: 641] Called By: trans_log_flush_generic() [transactions.c: 380] API Fcn.: _sql_execute() returned 0 SQL Error: Records: 300 Duplicates: 0 Warnings: 0 Error: Unable to allocate sufficient storage for queryPointer!