Thread: Memory Problem

    #1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2012
    Posts
    2
    Rep Power
    0

    Memory Problem


    Hello together,

    i have an memory problem with the firebird.

    My system:
    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
    oder
    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?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2010
    Posts
    43
    Rep Power
    5
    Why are you re-posting your problem here? I thought the discussion in the German Entwickler-Forum was sufficient?
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2012
    Posts
    2
    Rep Power
    0
    I thought I might find here a few more information.
    Problem is solved!

    Don't use firebird 32bit application under Windows 7 64bit!

IMN logo majestic logo threadwatch logo seochat tools logo