New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
shrink db via api [CORE2226] #2654
Comments
Commented by: @dyemanov Backup/restore can be performed using the Services API as well. |
Commented by: Staffan Bergbom (stab) I really agree that this is a MUST. Would be glad to hear from you about your plans to fix this Kindly |
Commented by: @dyemanov If your database is growing in the described conditions, then I'm afraid something is wrong with transaction management in your system. Firebird itself doesn't have such a problem, it just requires some discipline from client applications, i.e. not keeping snapshot transactions active for a long time and caring about the sweep. |
Commented by: @livius2 I suppose that you use some bad driver or like Dimitry say your transaction management is bad you can check long running transactions in FB2 using monitoring tables |
Submitted by: Miha Vrhovnik (mvrhov)
AFAIK the only way to remove unused pages from DB is using backup/restore functionally using external executable. This is really bad for embedded version. I think that for embedded version there should be API which would compact/reorder data in database and remove unused pages so DB file after that would be smaller.
The text was updated successfully, but these errors were encountered: