Dowload of linkchecker details returns timeout about curation-dashboard

[wowasa]

I thought it's the database issue we had already a long time ago. But instead it is a default timeout when writing to StreamingResponseBody which is exceeded for large downloads.
The net simple recommends to increase the timeout:
spring.mvc.async.request-timeout = 3600000
(see for example https://stackoverflow.com/questions/42877498/async-timeout-downloading-a-large-file-using-streamingresponsebody-on-spring-boo)

[wowasa]

unfortunately the issue is a bit more complex. Apparently the cause of the issue is the fact that that two Stream-methods StatusDetailRepository.findAllByCategory and StatusDetailRepository.findAllByProvidergroupnameAndCategory are not behaving in the supposed way. My idea was to read the records from the database and to write each record directly to the OutputStream without any need to store the whole recordset. But from debugging and an article I found (see https://medium.com/predictly-on-tech/spring-data-jpa-batching-using-streams-af456ea611fc) its quite likely that a Stream of Objects is created in memory first, which might take a lot of time, then we iterate through the Stream and write each Object to the OutputStream

[wowasa]

implemented in 6.1.2

[wowasa]

for the moment the streaming only works when the Download controller uses the EntityManager directly