Commented by: @hvlad

I see no bug there. Engine just do what you ask it to do.

Commented by: @dyemanov

Sorry, but this is nonsense. Restore with a small cache is likely to be unacceptedly slow. But if you insist, then it can be easily achived with the -buffers switch for GBAK during restore.

Regardless, if you do need to restore immediately while your original database is still being accessed by users, it's much better to do that on a separate host. It's not only about memory consuption but also about CPU and disk usage that would make your original database to perform badly while the restore process is running.

I tend to reject this request in both incarnations (improvement or bug).

Commented by: @livius2

>>Restore with a small cache is likely to be unacceptedly slow.

slower is swap to disk when FB server consume all memory..
and about your worry abut disc and CPU consumption i know that but client can accept this slowdown for 10 minutes but never accept then he/she must buy another machine only for restore process

but "-buffers" is ok. but after restore process we must then set buffers again to some value (i do not know what is "default" when server see it then use value not from database only from config)

and with command line this is ok but by service this is not possible by one service (or i missing something)
will be good to see e.g. -buffers_at_restore - or something similar

Commented by: @dyemanov

> slower is swap to disk when FB server consume all memory

Only in your case. Almost everybody else ask us developers to speed up the restore process in the any possible way.

> but after restore process we must then set buffers again to some value

Setting it to zero (e.g. with GFIX) makes the config setting actual again.

> but by service this is not possible

Both are possible: isc_spb_res_buffers for the GBAK service and isc_spb_prp_page_buffers for the GFIX service.

Commented by: @livius2

>>Both are possible: isc_spb_res_buffers for the GBAK service and isc_spb_prp_page_buffers for the GFIX service

i see that now that feature already exists
and i must dig in source code of component what i use (it have not this option) or search for some updates

thanks for asnwer also at "support question"
isc_spb_res_buffers, isc_spb_prp_page_buffers is what i looking for
this ticket should be closed

Commented by: @livius2

i dig source code an i see that
my previous message is wrong
you say in "GFIX" service - i misss this

this should be possible at "GBAK" service as one running statement

Commented by: @dyemanov

What's wrong with calling two services sequently?

Commented by: @livius2

that you must manage two services for doing restore process not one