KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

Does Koolreport support incremental database queries ? #3158

Open Neha Gupta opened this topic on on Sep 29, 2023 - 2 comments

Neha Gupta commented on Sep 29, 2023

Hello:

I have a conceptual question, for which I could not find any documentation. Therefore posting it here.

My requirement is the following: . We have a koolreport which takes input a date range. (Start and End Date) . There should not be a restriction on the date range (the date range could be in months. Data for 6 months etc...) . The report structure is such that relevant data is returned in context of 1 day. For example even if date range is say 1 week, the data can be shown day wise. . Since there should not be a restriction on date range, if we try to query entire date range at once, we run into memory issues. . Therefore architecturally we are thinking of incrementally querying database 1 day at a time and managing incremental load of data using pagination. . Is this possible in koolreport and if yes, how to achieve it ?

Thanks in advance for the help.

Best Regards

Sebastian Morales commented on Oct 3, 2023

KoolReport has not supported incrementally data processing yet but we are investigating methods to deal with huge data including caching and incremental processing. This would probably takes months or a year to have a solution.

Neha Gupta commented on Oct 3, 2023

Thank you very much for your response.

Best Regards

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo
help needed

None