Sugerencias sobre un procesador P4 DUALCORE en firebird

[RolphyReyes]

Saludos.

Aqui hay algo que te puede ayudar, extraido del Firebird_v1.5.3 Release Notes:

CpuAffinityMask

(was cpu_affinity in isc_config/ibconfig). With Firebird SuperServer on Windows, there is a problem
with the operating system continually swapping the entire SuperServer process back and forth
between processors on SMP machines. This ruins performance. This parameter can be used on
SMP systems on Windows to set Firebird SuperServer's processor affinity to a single CPU.

Caution

Firebird Superservers, up to and including Release 1.5, may not support the Hyperthreading feature
of some later-model motherboards on Windows. To avoid balancing problems, you may
need to disable hyperthreading at system BIOS level.

CpuAffinityMask takes one integer, the CPU mask.

Example

CpuAffinityMask = 1

only runs on the first CPU (CPU 0).

CpuAffinityMask = 2

only runs on the second CPU (CPU 1).

CpuAffinityMask = 3

runs on both first and second CPU.

Calculating the affinity mask value

You can use this flag to set Firebird's affinity to any single processor or (on Classic server) any
combination of the CPUs installed in the system.
Consider the CPUs as an array numbered from 0 to n-1, where n is the number of processors in-
New Configuration Files
60
stalled and i is the array number of a CPU. M is another array, containing the MaskValue of each
selected CPU. The value A is the sum of the values in M.
Use the following formula to arrive at M and calculate the MaskValue A:

Mi = 2I
A = M1 + M2 + M3. . .

For example, to select the first and fourth processors (processor 0 and processor 3) calculate as
follows:

A = 20 + 23 = 1 + 8 = 9