Hi
After replacing the SQLAPI library with the latest version(trail)
The problem is gone!
-gili
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> 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