I just migrated my Firebird 2.5 server to Firebird 3, using NodeJS 4.2.2 server and node-firebird.

My problem is the increase in RAM when I start using my application under Firebird 3 which is much more greedy, I switch from a usual 50mo consumption to 200mo and more.

Is this normal? Is Firebird 3? Is node-firebird badly handling its connection pools? Is that something else?

edit : 04/05/2017

Today, I Have execute a test difference between firebird 2.5 and firebird 3.0.3 , so the result of execute of stored procedure are :

fb 2.5 :

RAM used : 122080ko

Analysis :

• Query Time

Prepare : 0,00 ms Execute : 71 453,00 ms Avg fetch time: 0,00 ms

• Memory

Current: 174 393 144 Max : 175 580 408 Buffers: 2 048

• Operations

Read : 7 654 Writes : 7 325 Fetches: 85 273 011 Marks : 1 167 644

fb 3.0.3

RAM used : 170052ko

Analysis:

• Query Time

Prepare : 0,00 ms Execute : 71 500,00 ms Avg fetch time: 0,00 ms

• Memory

Current: 215 635 168 Max : 218 143 880 Buffers: 2 048

• Operations

Read : 7 799 Writes : 5 163 Fetches: 44 280 137 Marks : 1 132 112