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

2017-12-05 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
05.12.2017 10:07, Marcel Brink mbr...@xploration.onmicrosoft.com [firebird-support] wrote: > Does anyone have an idea why this happens only after around 20 minutes and > not every time ? You should, probably, turn performance counters output in trace as well. May be in these 20 minutes some

[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 varying