XLS Export - Memory Problem
Hello,
I have an application (20 MB Memory usage) when i prepare report application size getting 100 Mb, when i say export app size is gettin 400-450 Mb. (for a 50.000 row, 12 Mb size file export operation) and after process finished memory usage stay on 100 Mb.
I'm not sure if memory usage can be reduced from 400 mb, because when i try to export file in multihtread (with 3 or more threads) application getting out of memory error.
I set use file cache option on report.engineoptions and filter but nothing changed.
I tried to use DOAC (allround automations) and ODAC (Devart) connection components and also tried loading data to TDXMemDataSet and close db connection but nothing changed.
Does anyone has any idea?
And is it possible to export a file to excel (Excel is not installed)
Note: I use Win 7 64 Bit Machine, 4 GB Ram installed. Intel i5 Processor
I have an application (20 MB Memory usage) when i prepare report application size getting 100 Mb, when i say export app size is gettin 400-450 Mb. (for a 50.000 row, 12 Mb size file export operation) and after process finished memory usage stay on 100 Mb.
I'm not sure if memory usage can be reduced from 400 mb, because when i try to export file in multihtread (with 3 or more threads) application getting out of memory error.
I set use file cache option on report.engineoptions and filter but nothing changed.
I tried to use DOAC (allround automations) and ODAC (Devart) connection components and also tried loading data to TDXMemDataSet and close db connection but nothing changed.
Does anyone has any idea?
And is it possible to export a file to excel (Excel is not installed)
Note: I use Win 7 64 Bit Machine, 4 GB Ram installed. Intel i5 Processor