Has anyone had any luck with this problem? I have seen this issue reported on this forum over and over with no solution. I have adjusted all of my php.ini settings to include php execution time and tons of memory. The problem I am having is that when I export a large table to xls the script runs for awhile and then dies Any ideas?? I am stuck.
Hi beckjoh,
Remember that XLS files has a row limit, about 65000 max. Have you tried to export to XLSX format (here the limit is over a million rows)?
This happens ALL the time at big tables xls exports. My solution is to: (KISS approach)
- Try using csv instead for export.
- Reduce the number of columns
- Prefer format-less columns (number roundups, date formatting, etc)
- Avoid on_row events, especially if the event rewrite a field or do a DDBB query.
- Avoid using field lookups, especially SQL ones. In lookups, scriptcase is very inefficient, because it will do a full SQL query for every lookup column, in every row! (This is bad, really bad!)
- Prefer to do well made SQL querys, with adequate joins, to avoid using field lookups, better so, use a view to make the result table lookup-less (in scriptcase perspective) In scriptcase, a view is like a real table, fully compatible in search, filter, pagination, export, refinate search, pivot table, charts, etc.
Give it a try, and AVOID FIELDS LOOKUPS!