Currently we are using Xojo as an API for our front end client. We are seeing issues with our Postgres database memory, over time the memory usage from the connection related to the API will kill the PSQL box as it runs out of available memory. The time can be dependant on the amount of users that are accessing the website. In order to get the memory back we have to restart the API. As soon as this is restarted the memory is returned.
We have some other worker apps (Xojo Console Apps) that connect to the same DB and they are not increasing the memory like the API does. These worker apps check the database every second, the only differences between the two are the API is using `Prepared Statements` and the workers are not.
Has anyone experienced any issues with memory increase over time using `Prepared Statements`? If so are the any suggestions to clear this memory.
Xojo 2019 r3.1 is being used to build currently