FazBrowse GitHub Viewer | Trending |
URL:
| Home
Tools: [Download Repo ZIP]   [Original HTTPS Page]

benchmark: complete the sqlite is-transaction fix by geeksilva97 · Pull Request #65218 · nodejs/node · GitHub

/ node Public

benchmark: complete the sqlite is-transaction fix - #65218

Merged
nodejs-github-bot merged 1 commit into
nodejs:mainfrom
geeksilva97:benchmark-sqlite-is-transaction
Aug 13, 2026
Merged

benchmark: complete the sqlite is-transaction fix#65218
nodejs-github-bot merged 1 commit into
nodejs:mainfrom
geeksilva97:benchmark-sqlite-is-transaction

Conversation

geeksilva97 commented Aug 11, 2026
edited
Loading

Copy link
Copy Markdown
Contributor

This PR removes the Logical AND assignment. It was causing the benchmark to call the isTransaction only once when the getter was returning false.

With the deadCodeElimination being false, the right side never runs.

Before

$ ./node benchmark/sqlite/sqlite-is-transaction.js
sqlite/sqlite-is-transaction.js transaction="true" n=10000000: 64,634,434.23269218
sqlite/sqlite-is-transaction.js transaction="false" n=10000000: 871,137,051.6366488

After

$ ./node benchmark/sqlite/sqlite-is-transaction.js
sqlite/sqlite-is-transaction.js transaction="true" n=10000000: 64,021,357.52487029
sqlite/sqlite-is-transaction.js transaction="false" n=10000000: 66,274,377.580040805

Signed-off-by: geeksilva97 <edigleyssonsilva@gmail.com>

Copy link
Copy Markdown
Collaborator

Review requested:

  • @nodejs/performance

nodejs-github-bot added benchmark Issues and PRs related to the benchmark subsystem. sqlite Issues and PRs related to the SQLite subsystem. labels Aug 11, 2026
geeksilva97 requested review from H4ad and RafaelGSS August 11, 2026 18:07

H4ad left a comment

Copy link
Copy Markdown
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Choose a reason Spam Abuse Off Topic Outdated Duplicate Resolved Low Quality

The initial idea was to assert this never returns invalid value due any optimization (such as fast apis)

But this works as well, thanks for the fix

Copy link
Copy Markdown
Contributor Author

The initial idea was to assert this never returns invalid value due any optimization (such as fast apis)

But this works as well, thanks for the fix

No prob. Btw, this is my first time changing benchmark stuff. Do we need CI for it?

geeksilva97 added the author ready PRs that have at least one approval, no outstanding review comments, and a CI started. label Aug 11, 2026

github-actions Bot commented Aug 12, 2026
edited
Loading

Copy link
Copy Markdown
Contributor

Benchmark GHA (sqlite / sqlite-is-transaction): https://github.com/nodejs/node/actions/runs/31584406184

Results

[!WARNING]
Do not take GHA benchmark results as face value, always confirm them
using a dedicated machine, e.g. Jenkins CI.

Benchmark results:

                                                               confidence improvement accuracy (*)   (**)  (***)
sqlite/sqlite-is-transaction.js transaction='false' n=10000000                 0.06 %       ±2.36% ±3.11% ±3.99%
sqlite/sqlite-is-transaction.js transaction='true' n=10000000                 -0.62 %       ±2.38% ±3.13% ±4.02%

Be aware that when doing many comparisons the risk of a false-positive
result increases. In this case, there are 2 comparisons, you can thus
expect the following amount of false-positive results:
  0.10 false positives, when considering a   5% risk acceptance (*, **, ***),
  0.02 false positives, when considering a   1% risk acceptance (**, ***),
  0.00 false positives, when considering a 0.1% risk acceptance (***)

[!WARNING]
Do not take GHA benchmark results as face value, always confirm them
using a dedicated machine, e.g. Jenkins CI.

aduh95 added the commit-queue Add this label to land a pull request using GitHub Actions. label Aug 12, 2026
nodejs-github-bot merged commit f914e45 into nodejs:main Aug 13, 2026
47 checks passed

Copy link
Copy Markdown
Collaborator

Landed in f914e45

nodejs-github-bot removed the commit-queue Add this label to land a pull request using GitHub Actions. label Aug 13, 2026
aduh95 pushed a commit that referenced this pull request Aug 25, 2026
Signed-off-by: geeksilva97 <edigleyssonsilva@gmail.com>
PR-URL: #65218
Reviewed-By: Vinícius Lourenço Claro Cardoso <contact@viniciusl.com.br>
Reviewed-By: Antoine du Hamel <duhamelantoine1995@gmail.com>
aduh95 pushed a commit that referenced this pull request Aug 25, 2026
Signed-off-by: geeksilva97 <edigleyssonsilva@gmail.com>
PR-URL: #65218
Reviewed-By: Vinícius Lourenço Claro Cardoso <contact@viniciusl.com.br>
Reviewed-By: Antoine du Hamel <duhamelantoine1995@gmail.com>
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode characters
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

author ready PRs that have at least one approval, no outstanding review comments, and a CI started. benchmark Issues and PRs related to the benchmark subsystem. sqlite Issues and PRs related to the SQLite subsystem.

Projects

None yet

Development

Successfully merging this pull request may close these issues.

4 participants


Back | FazBrowse Home | New Git URL