Subject Re: [Firebird-Java] Users Connected
Author Jim Starkey
Francisco Antonio Vieira Souza wrote:

> Thanks a lot for your long answer.
>
> Well, about backingup and restoring, the reason is that when we perform
> that its is made a kind of "cleaning" in the DB, am I right?
>
> My user makes lots of lots of INSERT and DELETEs, so after a while the
> DB gets slower.
>
Database performance should not degrade significantly even with lots of
inserts and deletes. The space should be reused as back versions are
garbage collected, so within a delta, you shouldn't see database growth
after some minor initial growth other than for new records. It sounds
like something is wrong and should be investigated.

--

Jim Starkey
Netfrastructure, Inc.
978 526-1376