Question sessionLogs.h2.db Very big

Hello,
When I am executing my process which is too big and takes a lot of time. The sessionLogs.h2.db does not stop growing it takes a lot of Hard disk space it reaches 30 GO, the process becomes saturated, stambia no longer responds.

I'm looking for a way to set logs to limit logs, or another solution.

thank you

Regards,
Zineddine

Hi,

We advise to purge the log database on regular basis to free up space and resources on it.
For further information, you can consult this article that explains how to purge the log database:
stambia.org/doc/106-stambia-di-software/...ntime-s-log-database

You can moreover specify the level of information you want to log for each of your sessions.
This helps to reduce the amount of data stored in the database for them.
The following article explains how to perform that:
stambia.org/doc/71-development-hints-and...evel-of-each-session

We also suggest to use a dedicated database for the Runtime logs, to avoid the internal H2 database limitations (File disk grow, ...)
This article shows how to do that:
stambia.org/doc/106-stambia-di-software/...a-rdbms-log-database

Do not hesitate if you need more details or clarification.