Hi, I have finally made a node.js driver for firebird, so I connect to directly to fb on the network protocol asynchronously. I was not very comfortable at the beginning, I was expecting it will not works, because fb have not pipelining support (cf: pipelining 11 Apr 20112). but it works anyway, cool :3
and I decided to make tests with connection and without connection pooling, and this is the results select * from rdb$relations on a local host customer database pool size: 1 -> 88.52 ms / query pool size: 5 -> 79.78 ms / query pool size: 10 -> 74.5 ms / query pool size: 20 -> 74 ms / query empty database pool size: 1 -> 0.812 ms / query pool size: 5 -> 1.019 ms / query pool size: 10 -> 1.253 ms / query pool size: 20 -> 1.21 ms / query I am doubtful, I do not understand these results. Why it is faster to use one connection with small data size ? I was not expecting async mode to be so fast, I very happy with it, but I would like to understand. thank you ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
