Thanks for the reply.

You are right that 30Mb is not big, but it is an increase with almost
400% ( from 8Mb to 30Mb ) and we are not inserting new data, only
updates.

We are running Firebird WI-T6.2.679 Firebird Release Candidate 2 on a
Windows XP Prof ( also we have the problem on Win98SE ). We use the
Interbase components delievered with D5 Enterprise.

It takes about 45min to update all records in a table with about 9000
records. But we are using one big transaction for this.

I did a search on the internet and found a thread with simular
problems like we have, and this was the reason for his problem,
updating records with one transaction because Firebird than needs to
hold a copy of the data for each change in the database.


Regards,
Peter

--- In ib-support@y..., Svein Erling Tysvaer
<svein.erling.tysvaer@k...> wrote:

> Everix,
>
> 30Mb is a very small database to be Firebird, so this is not your

problem.

> And FB never releases any disk space, just reuses it when

necessary, so it

> is no surprise that it shrinks like this following a restore. You

do not

> say which version of FB you are using or which components you use

in Delphi

> - which could be useful to know.
>
> As a wild guess, do you have any long running transactions? What

about

> indexes? And how slow is 'very slow'?
>
> You must probably tell us a lot more for us to help you find the

solution

> to your problem,
> Set
>
> At 12:04 12.11.2002 +0000, you wrote:
> >Hello all,
> >
> >We are developing a program using FireBird and Delphi 5 which
> >register every 5 minutes a couple of temperatures.
> >The program is working well but at a given moment, the access to

the

> >database became very slow and the hard disk of the server does a

lot

> >of activity.
> >
> >When looking to the database file, we noticed that the file was
> >growed from appr. 8Mb to 30Mb and after this the database is very
> >slow.
> >When we backup and restore the database, it is back the size of

appr.

> >8Mb.