Are you performing your "read only queries" from a long running non-read
committed transaction? If so I would suspect that modifications made from
other connections will make the database grow.

If so, either use a read only read committed transaction or restart your
transaction frequently eg. don't use long running transactions.

/smn

> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of cosamektoo
> Sent: 4. maj 2005 12:57
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] For SQLAPI users IMPORTANT
>
> 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.
> 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.
> Hope I helped anyone.
> 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.
> Thanks
> -gili
>
>
>
>
> Visit http://firebird.sourceforge.net and click the Resources
> item on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
> Yahoo! Groups Links
>
>
>
>
>
>
>