Hi team, in one of our current applications we need to do "massive" data query (perhaps a few thousand records of tables with at least 20 columns) for use in foreign / excel systems via URL. We have seen that datalist can consume a large amount of memory when exporting to excel even generating heap space errors. On the other hand, reports via jasper can also work for this purpose but require significant amounts of time to format and download. Is there any other possibility of querying "flat" data via URL for these purposes?
Hi team, in one of our current applications we need to do "massive" data query (perhaps a few thousand records of tables with at least 20 columns) for use in foreign / excel systems via URL. We have seen that datalist can consume a large amount of memory when exporting to excel even generating heap space errors. On the other hand, reports via jasper can also work for this purpose but require significant amounts of time to format and download. Is there any other possibility of querying "flat" data via URL for these purposes?