Improve performance of JPA scanAll

[fjtirado]

See https://github.com/quarkiverse/quarkus-flow/pull/356/changes#r2980511752 for problem statement

The good solution will be to use manual transaction handling through plain jdbc, but this will require some time.