Subject Re: Classic server uses a lot of memory depending on client connection
Author jegazarco
> Well, if this is the only record available, then it simply tells you the
> memory allocated and used for an attachment (MON$STAT_GROUP = 1).
>
> What's your page size and page buffers value at database-level?
>
>
> --
> With regards,
>
> Thomas Steinmaurer

Hello Thomas, page size is 8192. What is strange is that depending of what is connected the process consume a lot of memory. The application connects, and executes one stored procedure to record that the user has logged in and returns configuration for that user. When executing this stored procedure, firebird uses near 90MB RAM. Before running the stored procedure, uses 5 MG RAM.

I have connected with isql, and when i execute the procedure, the memory usege grows. The procedure is very simply and only read records from some tables, records the login in one table and return one row.

The setup of classic server is the default installation.

Regards, Jesus Garcia