tabs ↹ over ␣ ␣ ␣ spaces

by Jiří {x2} Činčura

FbNetExternalEngine 2.0 released – functions and performance

8 Jul 2019 .NET, Firebird

It has been few exciting weeks and days lately and today I’m happy to introduce you to FbNetExternalEngine version 2.0. This version adds support for functions and also improves performance (on top of previous improvements).

Let’s start with functions. It’s pretty simple. You have a static function that accepts and returns one of the supported types (see docs) and you can then declare in the database using the external name and engine clauses. Usage is as with any other function. Comparing the performance, empty function invocation takes about 2,6 μs on my machine and is about 2,6 times slower compared to PSQL. Obviously once the function actually does something the performance against PSQL starts improving.

Speaking about performance. I have spent quite some time in various tools looking for ways to improve. And it was always humbling – when I thought I can’t find a way to make that part of code faster, I always found a way later and it was not even so much hacking and so on. Both functions and procedures benefit from any improvement, because there’s a lot code shared across both paths. To give you some numbers, compared to previous release, the procedures are about 10-15% faster. And I’m not done. I have already few ideas how to improve even more, if it works. Can’t wait to try it out (but I also wanted to release the functions support).

Documentation, examples and performance numbers are available on this page.

Last but not least big thanks to SMS-Timing for sponsoring my work on the plugin.

Profile Picture Jiří Činčura is an independent developer focusing on data and business layers, language constructs, parallelism and databases. Specifically Entity Framework, asynchronous and parallel programming, cloud and Azure. He's Microsoft Most Valuable Professional and you can read his articles, guides, tips and tricks at www.tabsoverspaces.com.