You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
The text was updated successfully, but these errors were encountered:
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
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.
The text was updated successfully, but these errors were encountered: