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

Memory is used for different things. Page caching, metadata caching,
sorting etc ... You didn't answer what the page buffers value for the
database is?

Run gstat -h and report back.


--
With regards,

Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thomas/

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!