Subject | Firebird 2.5 backup takes 2 hours (1 minute in 2.0) |
---|---|
Author | |
Post date | 2013-10-23T18:28:34Z |
I am working with Firebird from 1.5 many years ago. I migrated Firebird databases from 2.0 to 2.5.2 some month ago.
In general works fine, but I see that it is slower in some SQL consults, maybe 20% more. I can see it our test units but it is not critical.
The big problem is when sometimes, not always, the user does a backup. It can take 2 hours for a 250MB database. The same operation in FB 2.0 takes 1-2 minutes in 2.0.
It is not my PC because it is happening in all our customers around the world: different hardware, operating system, etc.
It seems that in network mode, it does not happen, only happen sometimes when the connection is in local mode.
Has somebody have the same problem?
Thank you
In general works fine, but I see that it is slower in some SQL consults, maybe 20% more. I can see it our test units but it is not critical.
The big problem is when sometimes, not always, the user does a backup. It can take 2 hours for a 250MB database. The same operation in FB 2.0 takes 1-2 minutes in 2.0.
It is not my PC because it is happening in all our customers around the world: different hardware, operating system, etc.
It seems that in network mode, it does not happen, only happen sometimes when the connection is in local mode.
Has somebody have the same problem?
Thank you