mORMot Open Source

Hello everyone,

I’m working with Delphi, mORMot 2 and FireDAC, and I have an issue related to service timeouts.

In my system, all business logic is implemented in the database. I use mORMot only as an HTTP layer to access and process data.
In some cases, executing a stored procedure may take a long time. When this happens, I face timeout problems on the mORMot server side, and the service instance is released even though the database processing has not finished.

To work around this, I temporarily disable the global service timeout using:

(RestServer.Services.Index(0) as TServiceFactoryServer).TimeoutSec := 0;

However, this affects all connections using the same service, which is not desirable.

My question:
Is there a way to disable or adjust the timeout only during the execution of a long-running process, without impacting other connections or service calls?

Any guidance or best practices would be greatly appreciated.

Thank you!