09.05.2018 20:02, liviuslivius wrote:

> Ok, i understand temp file caching but why Firebird create this temp
> file at all and how to prevent this?

Either some GTT was used or temporary blob storage was requested. Why do
you want it to be prevented?

> And second question, why file handle is still active?

In SS, it will be closed/deleted as soon as all connections are gone.


Dmitry