a large number of rows when retrieving data calling Table :: create.

Eo Yoonmin commented on Feb 16, 2019

Dear great Team!! How can I solve the following situations?

There is a large number of rows when retrieving data with input package and calling Table :: create.

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 10489856 bytes) in -~~/libraries/koolreport/packages/cache/FileCache.php on line 64 A PHP Error was encountered Severity: Error

Message: Allowed memory size of 134217728 bytes exhausted (tried to allocate 10489856 bytes)

Filename: cache/FileCache.php

Line Number: 64

Backtrace:

KoolReport commented on Feb 16, 2019

Your data is large for cache, you may just remove the

use \koolreport\cache\FileCache;

for now!

Could you please let me know how large is your data? How many row do you retrieve at once from database. If possible please try to select only the necessary columns.

Rohit Savaliya commented on Jun 19, 2021

I have same issue with 40,000 records Error in Fatal error: Allowed memory size of 1073741824 bytes exhausted (tried to allocate 528384 bytes) in vendor\koolreport\pivot\PivotUtil.php on line 658

Sebastian Morales commented on Jun 21, 2021

In case your number of data rows exceeds your PHP memory a good solution is to use DataTables' server side processing. Pls check our demo and docs at these links:

https://www.koolreport.com/examples/reports/datagrid/server_processing/

https://www.koolreport.com/docs/datagrid/datatables/#serverside

Rgds,

Future Lab commented on Aug 29, 2021

But cant export in a good way

Sebastian Morales commented on Aug 30, 2021

Which kind of export are you doing, excel or pdf or others?

KoolReport's Forum

A large number of rows when retrieving data calling Table :: create. #682

Build Your Excellent Data Report