May 14th, 2012, 05:00 AM
Join Date: May 2012
Time spent in forums: 22 m 36 sec
Reputation Power: 0
i have an memory problem with the firebird.
firebird 2.5.1 windows superclassic server
Datebasefile: ca. 10GB filesize, some tables has more than 2 mio. records.
Pageseizes tested: 16384, 8192, 4096
Page Buffer tested: 75 - 256
When i use sql statements like:
select count (x), sum(x) from table
alter index y inactive
alter index y active
then i have a problem with the memory.
The free memory from the windows system reduced from 2 GB to 0,5-1GB. There ist no process i can see with the process explorer that use this memory. The process explorer shows the memory the is used in the column CACHE WS.
When i stopp my process and all connection are closed, than the memory is freed.
The problem ist the size of the memory that is used by this commands, and that it will not freed automatically when the statement has commited.
I think, by pagesize from 8192 an Pagebuffers from 75 the cache is heavy smaller than 1-1.5 GB ram. My process use 75-100 connections.
I habe the same problem with the memory when i use tools like IBExpert with this sql statements, so i think it is not a problem from my process.
Has anybody an idea?