Subject | Out of memory on Fb2.0.1 Classic |
---|---|
Author | elangmas@aol.com |
Post date | 2007-05-03T01:58:23Z |
Hello all,
I running Classic Server Fb2.0.1 on server P4 3.2Ghz with HT, Winxp Pro Sp2, 1Gb Ram, 250Gb Hdd.
I am experience out of Memory after after running a program.
Message "Out of memory while expanding memory stream"
Program runs on client 1.8 Core 2 duo, Winxp Pro Sp2, 1,5Gb Ram, 80Gb Hdd.
Below setting on my Firebird.conf that has changed, other parameters remain the same.
Question: Currently running Fb1.0 for the same program, but never experience out of memory,
just Migrate to Fb2.0.1, am I left something on the firebird config or else....hello friends please advice
# ----------------------------
# In-memory sorting module
#
# The amount of memory allocated for each sort block.
#
#Type: integer
#
SortMemBlockSize = 4194304 # increase from 1mb to 4mb for classic
#
# The maximum amount of memory to be allocated by the in-memory
# sorting module.
#
# For Classic servers, this setting is defaulted to 8 MB.
# Although it can be increased, the value applies to each client
# connection/server instance and thus consumes a lot of memory.
#
#Type: integer
#
SortMemUpperLimit = 33554432 # increase from 8mb to 32mb for classic
# ----------------------------
# ----------------------------
# Which CPUs should be used (Windows Only)
#
# In an SMP system, sets which processors can be used by the server.
# The value is taken from a bit map in which each bit represents a CPU.
# Thus, to use only the first processor, the value is 1. To use both
# CPU 1 and CPU 2, the value is 3. To use CPU 2 and CPU 3, the value
# is 6. The default value is 1.
#
#Type: integer
#
CpuAffinityMask = 3
________________________________________________________________________
AOL now offers free email to everyone. Find out more about what's free from AOL at AOL.com.
[Non-text portions of this message have been removed]
I running Classic Server Fb2.0.1 on server P4 3.2Ghz with HT, Winxp Pro Sp2, 1Gb Ram, 250Gb Hdd.
I am experience out of Memory after after running a program.
Message "Out of memory while expanding memory stream"
Program runs on client 1.8 Core 2 duo, Winxp Pro Sp2, 1,5Gb Ram, 80Gb Hdd.
Below setting on my Firebird.conf that has changed, other parameters remain the same.
Question: Currently running Fb1.0 for the same program, but never experience out of memory,
just Migrate to Fb2.0.1, am I left something on the firebird config or else....hello friends please advice
# ----------------------------
# In-memory sorting module
#
# The amount of memory allocated for each sort block.
#
#Type: integer
#
SortMemBlockSize = 4194304 # increase from 1mb to 4mb for classic
#
# The maximum amount of memory to be allocated by the in-memory
# sorting module.
#
# For Classic servers, this setting is defaulted to 8 MB.
# Although it can be increased, the value applies to each client
# connection/server instance and thus consumes a lot of memory.
#
#Type: integer
#
SortMemUpperLimit = 33554432 # increase from 8mb to 32mb for classic
# ----------------------------
# ----------------------------
# Which CPUs should be used (Windows Only)
#
# In an SMP system, sets which processors can be used by the server.
# The value is taken from a bit map in which each bit represents a CPU.
# Thus, to use only the first processor, the value is 1. To use both
# CPU 1 and CPU 2, the value is 3. To use CPU 2 and CPU 3, the value
# is 6. The default value is 1.
#
#Type: integer
#
CpuAffinityMask = 3
________________________________________________________________________
AOL now offers free email to everyone. Find out more about what's free from AOL at AOL.com.
[Non-text portions of this message have been removed]