Subject Re: When is cache cleared on SuperServer
Author
> ---In firebird-support@yahoogroups.com, <Martin.Koeditz@...> wrote :

> if I remember right, SuperServer holds cached data as long as connections exist. So if the last user disconnects the FB cache is cleared. Is that correct?


  Yes

 

> When I connect with Flamerobin the table MON$ATTACHMENTS shows me two other attachments: CACHE WRITER and GARBAGE COLLECTOR.

> Does they still exist after last log out


  No, they finished with last user connection.


> and will the cache be cleared?


sure


> Do they influence the cache process?


  Of course.

Regards,
Vlad

PS probably you will be interesting in "database linger" feature of fb3:
http://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-ddl-enhance.html#rnfb30-ddl-enhance-linger