RE: [firebird-support] Re: Slow execution of Stored Procedure after 20 min. inactivity

2017-12-06 Thread Marcel Brink mbr...@xploration.onmicrosoft.com [firebird-support]
Hello, With “idle” I mean no connections at all. I already found out the problem is related to a custom UDF dll, but it’s unclear to me why this only happens after 20 minutes. I added some logging to the UDF so I could see when the UDF was loaded and unloaded and the memory usage at those

[firebird-support] Slow execution of Stored Procedure after 20 min. inactivity

2017-12-05 Thread Marcel Brink mbr...@xploration.onmicrosoft.com [firebird-support]
Hello, After spending more than a week trying to resolve the following issue we hope someone has an answer on this. We have a database with about 230 tables and 200 stored procedures which is being used by our customers. Each customer have a dedicated installation with it's own database