| Subject | Re: Database randomly growing is size??? |
|---|---|
| Author | Martijn |
| Post date | 2011-02-04T06:26:20Z |
--- In firebird-support@yahoogroups.com, "timwilsonaus" <timwilsonaus@...> wrote:
You should also look for transactions that are not closed properly it tends to make your db growing.
What kind of application is using your database? Stays the same application active for the whole day? If not is it closing properly or just halted (I ve seen quit commands just calling halt instead of properly closing)
Martijn
>Keeps it growing if you do not backup/restore it? Maybe it is just extra room needed to do it's work.
> Have a database that for some reason overnight will double or triple in size from about 200MB up to about 600MB.
>
> Has anyone had similar issue or any suggestions as to what might cause this?
>
You should also look for transactions that are not closed properly it tends to make your db growing.
What kind of application is using your database? Stays the same application active for the whole day? If not is it closing properly or just halted (I ve seen quit commands just calling halt instead of properly closing)
Martijn