search

FirebirdSQL / firebird

Firebird server, client and tools
https://www.firebirdsql.org/
1.26k stars 217 forks source link

Provide ability to specify temporary TempCacheLimit value during restore via command line switch [CORE4328] #4651

Open firebird-automations opened 10 years ago

firebird-automations commented 10 years ago

Submitted by: @pavel-zotov

Is related to CORE3787

Votes: 4

Building indexes when restoring database takes lot of time if TempCacheLimit is not properly selected BEFORE beginning of this operation. The default value of TempCacheLimit (64M) mean that almost all sorting info will be swapped onto TempDirectories folder(s). And even if TempDirectories is set to /dev/shm ("ram disk") - it is not panacea because as soon as total size of TempCacheLimit is exceeded the speed of writing immediatelly decreases.

It will be useful to implement command line switch to GBAK utility for setting TempCacheLimit to some value - only at the time of restoring.

firebird-automations commented 10 years ago
Modified by: @dyemanov summary: Provide ability to select size of TempCacheLimit during restore via command line switch =\> Provide ability to specify temporary TempCacheLimit value during restore via command line switch
firebird-automations commented 10 years ago
Modified by: @dyemanov Link: This issue is related to [CORE3787](https://github.com/FirebirdSQL/firebird/issues?q=CORE3787+in%3Atitle) \[ [CORE3787](https://github.com/FirebirdSQL/firebird/issues?q=CORE3787+in%3Atitle) \]