Performance issues with Node v22 and v24

[titanism]

See benchmarks here https://github.com/forwardemail/sqlite-benchmarks - curious what you think the underlying issue might be?

[titanism]

See nodejs/node#60719

[m4heshd]

Interesting. Could you also include better-sqlite3 in your benchmark? That way, debugging will be easier. Also, please use the latest versions of the dependencies.

[titanism]

Will do @m4heshd one moment

[titanism]

@m4heshd it is now using better-sqlite3 as well, in addition to latest version in package.json

https://github.com/forwardemail/sqlite-benchmarks

I triggered workflow via gh workflow run daily-benchmarks.yml so the README should update momentarily with results from CI

[titanism]

@m4heshd results at https://github.com/forwardemail/sqlite-benchmarks?tab=readme-ov-file#better-sqlite3-no-encryption (I'm currently fixing it so v24 and v25 have results)

[m4heshd]

Judging by the available stats, the performance overhead from encryption/decryption is on par. But the hit taken by the runtime itself is definitely an issue. They're the only ones who can fix this. But I still need to see how vanilla BS3 performs on Node v24.

[sscarduzio]

is it still a risk to use node v25?