--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:

> > It is still taking 200MB of RAM. In one hour it increased by

alsmost

> > 30MB. There are around on an average 250 connections happen in 4
> > minutes. They all call stored procedures. Most of them update the
> > database. This is a multi-threaded application written in C. I am
> > using the C code generated by Embedded SQL (using gpre, after
> > removing the 'static' declarations). I have checked, thoroughly,

all

> > the transactions are commited or aborted properly.
>
> When you say "aborted" - I hope you mean "rollback"
> Alan
>

Yes, I mean rollback.

> >
> > Could it be the API I am using ? Should I try using the DSQL

APIs ?

> > How can I change the Page cache and what is the right value ?
> >
> > Any ideas ??? This is a production system and it has become an
> > embarrasment for me, because we I had reccommended to use

firebird

> > over the mysql.
> >
> > Regards:
> >
> > JS