At 10:57 AM 4/05/2005 +0000, you wrote:

>Hi
>After a long effort spend investigating why my db file became so large,
>I found the problem.
>We use SQLAPI to connect from a c++ application. It seems that even
>though We only performs read queries on that connection,leaving it open
>causes the problem.

It's a non-sequitur. The database can't grow if you are only reading from
it. A read-only Firebird database can be opened on a CD-ROM
drive. Something else is going on.

>I've also submitted this bug to SQLAPI support.
>
>The workarround I have for now is reconnecting every X minuts.
>This slows down considerably the growth of the db file.

If it is only being read from, this does not make any sense. If your
applications don't write to the database, convert it to a read-only
database. Nothing can make it grow then. :-)

>Hope I helped anyone.

I hope someone can help *you* !! If you have client applications that are
inserting to or updating tables, then the database will grow. The database
won't get smaller if records are deleted.

>If anyone knows this bug or have a better solution or have anything
>at all to say about this issue I'll be glad to here about it.

You need to find out where these writes are coming from, and fix the app so
that it commits work.

./heLen