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

250 simuultaneous connections is rather a lot for poor old superserver me
thinks...
Have you thought about connection pooling wih a middle tier?
There were some metrics someone here posted regarding memory requirements on
a per connection basis - I think 250 would be well over the size you
indicate here...
how much memory is ont he server?
I would guess that you need about 5-10 Gb of RAM for this sort of load..
Alan