> 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

>
> 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