Hello everyone!
Facing really annoying problem now. I need to export not a very big amount of rows in Report Module.
The report doesn’t contains joins or smth like that. My php.ini settings set like that:
|max_execution_time|3600|
|max_file_uploads|20|20|
|max_input_nesting_level|64|
|max_input_time|60|
|max_input_vars|1000|
|memory_limit|1024M|
|output_buffering|4096|
|post_max_size|60M|
|upload_max_filesize|60M|
in config.php $sugar_config[‘slow_query_time_msec’] = ‘10000’;
If I’m exporting from listview of selected module records export in like 6 seconds.
Any help will be appreciated.
You can check if those php.ini settings are effective in your system by going to Admin / Diagnostics / phpinfo. Sometimes people change the wrong php.ini (there are several), and sometimes people neglect to restart web server, and sometimes shared hostings have restrictions that block your settings.
If your problem is those settings, you should have a FATAL error in php_errors.log. No need to proceed blindly when you can just open your eyes to the log and see what the problem is (hopefully).
Another thing you might consider is that some specific row in your data can be causing errors. You can try different partial datasets to see if the problem is in the data.