Firebird CpuAffinityMask for 16 core server

Thanks for the reply, guys. I finally figured it out. Here's how:

make -DPACKAGE_BUILDING

make install

that finally got it compiled and installed.

Well, problem solved, after all. it was a bit of windows tunning and a bit of firebird tunning.

On the windows side, the setcache really did the trick in keeping the size of the file system cache under control, even with microsoft saying that i would not need this. i've just added a schedule task to run in every boot.

but even after lowering the memory use, my firebird database was still using 12,5% of my dual-quad-core box: 100% of one core, and performance was terrible (30s to select all tuples from a table with just 10 tuples).

after some monitoring with sinática (www.sinatica.com), i've realize that my database was sweeping. so i disable automatic sweep and added another schedule task to do sweeps on a 2-day basis.