0
I have a new Firebird Database, deployed less than 60 days, until then little used, in one day its size was 40 Megas, in less than 6 hours happens users complaint about slowness in the system, when checking the database is 126 Gigas. As this is possible, what might be happening? Any solution? How to check for possible errors? When analyzing apparently this information are only in a table, which logically I cannot open due to the amount of data.
Do a test, if you back up/store the base, it goes back to its original size?
– Geferson
What is this table related to? Are there open transactions consuming this bank? Why is there such a large amount of data?
– José Francisco
I can hardly manipulate any information in my Bank, it hangs too much by its size, I had the same problem a while and the Bank had 12 Gigas, I made a backup/ Store, was right, returned, however I need to know the reason for these occurrences.
– Guilherme
This table in question should not have large volume of data, I have no Blobs fields and no image in it. I do not know if the problem is only in it.
– Guilherme
Garbage Collection is active? your bank has a lot of Insert/update ? this seems to me to be garbage problem in the bank.
– Geferson
It has Quite Insert/update, but in this case the Bank very little handled, and in relation to Garbage Collection the Bank has less than 60 days of use, I do not believe to be garbage problem in the bank considering that it is little used, had only 40 Megas.
– Guilherme
What is the "Sweep interval"?
– EMBarbosa
How do I check which Sweep interval is?
– Guilherme