why it so slow?

[andrewvlgafc]

Hello.

Why this code is so slow?

MyCommit(tr) {

    return new Promise(function (resolve: any, reject: any) {
        var start1 = performance.now()
        tr.commit(function (err: any) {
            var end = performance.now()
            console.log('commitTransaction!!!!!!!!!!!!!',end - start1);	
            resolse()
       }
   }

}

console log say 235 ms !

in statement i have 25 not indexed reads and 4 indexed reads and 3 inserts

Thanks

[vvvait]

I’ve observed that this library performs exceptionally fast on Windows when using a localhost:db_alias connection. However, on Ubuntu, with the same connection method, the speed drops significantly—anywhere from 20 to 100 times slower. The same issue occurs when connecting over the network between Windows and Ubuntu, in both directions. This leads me to suspect that the issue might be related to the network stack implementation in Node.js.

For comparison, I tested the node-firebird-driver, which doesn’t exhibit these slowdowns, likely because it leverages the native Firebird library.

[fela98]

I also faced similar problems that you faced here. However, according to my testing it seems like it's also a lot faster with bun. When using bun, performance between Ubuntu and Windows is on par.