Database overload while retrieving images

0
In one of our applications we noticed a database overload on what seems to be a relatively simple database retrieve (related to images). Any pointers in how to solve this would be appreciated. The situation is as follows: I have an entity (with a generalization to image) We show this entity in a template grid:   The images are png files (sizes ranging from 5-40 kb). When clicking through these pages (''next page button'') a few times we see the following happening (both in the cloud metrics but also locally in PgAdmin). When multiple users are doing this the database becomes completely overloaded. Any suggestions on how to reduce the load?
asked
1 answers
1

Idea: Cache the images as base64 strings on SeamConstruction and use a format string widget to display them. https://appstore.home.mendix.com/link/app/264/

-Andrej

answered