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
