Skip to content

Conversation

gvozdvmozgu
Copy link
Collaborator

No description provided.

Copy link

Benchmark for 3ef0dcb

Click to view benchmark
Test Base PR %
DepthMap::from_parent 39.8±0.43µs 40.3±0.33µs +1.26%
fix_complex_query 9.3±0.06ms 9.6±0.49ms +3.23%
fix_superlong 97.8±5.72ms 106.8±11.29ms +9.20%
parse_complex_query 2.8±0.03µs 2.9±0.04µs +3.57%
parse_expression_recursion 5.0±0.05µs 5.2±0.03µs +4.00%
parse_simple_query 787.8±10.58ns 834.5±5.43ns +5.93%

@benfdking
Copy link
Collaborator

benfdking commented Apr 29, 2025

Do you have any view as to why everything got slower?

@gvozdvmozgu
Copy link
Collaborator Author

gvozdvmozgu commented Apr 29, 2025

Since merge #1554, performance has significantly decreased (Execution took: 332.133794ms on that PR).

@benfdking
Copy link
Collaborator

Yep I had to do that painful fix to get the python stuff working.

@gvozdvmozgu
Copy link
Collaborator Author

I don't have these issues locally, so it's possible that GitHub Actions is just under heavy load?

@gvozdvmozgu
Copy link
Collaborator Author

It seems that #1561 fixes the problem, and the numbers are more convincing again.

@gvozdvmozgu
Copy link
Collaborator Author

No, they’re still too noisy. Maybe we should run it at the very end—after everything else—and report the average over N runs.

@gvozdvmozgu gvozdvmozgu force-pushed the refactor/extract-crawl-logic branch from 65ee394 to 89c8a87 Compare May 1, 2025 07:56
Copy link

github-actions bot commented May 1, 2025

Benchmark for c717b8a

Click to view benchmark
Test Base PR %
DepthMap::from_parent 41.7±0.19µs 40.1±0.27µs -3.84%
fix_complex_query 9.3±0.04ms 9.3±0.58ms 0.00%
fix_superlong 91.8±5.80ms 99.4±14.68ms +8.28%
parse_complex_query 2.9±0.04µs 2.8±0.02µs -3.45%
parse_expression_recursion 5.1±0.05µs 5.0±0.06µs -1.96%
parse_simple_query 806.1±7.88ns 793.8±10.32ns -1.53%

Copy link

Benchmark for 33b887f

Click to view benchmark
Test Base PR %
DepthMap::from_parent 40.9±0.31µs 40.6±1.16µs -0.73%
fix_complex_query 9.8±0.07ms 9.5±0.26ms -3.06%
fix_superlong 98.3±1.83ms 94.1±6.55ms -4.27%
parse_complex_query 2.9±0.04µs 2.9±0.04µs 0.00%
parse_expression_recursion 5.1±0.06µs 5.1±0.04µs 0.00%
parse_simple_query 837.2±10.43ns 832.0±8.63ns -0.62%

Copy link

Benchmark for f115be5

Click to view benchmark
Test Base PR %
DepthMap::from_parent 40.4±0.25µs 40.0±0.33µs -0.99%
fix_complex_query 9.4±0.13ms 9.4±0.14ms 0.00%
fix_superlong 95.8±6.63ms 96.5±7.22ms +0.73%
parse_complex_query 2.9±0.03µs 2.9±0.03µs 0.00%
parse_expression_recursion 5.1±0.06µs 5.1±0.04µs 0.00%
parse_simple_query 814.1±6.80ns 800.6±22.36ns -1.66%

@benfdking benfdking merged commit 81acc89 into main Jun 21, 2025
41 checks passed
@benfdking benfdking deleted the refactor/extract-crawl-logic branch June 21, 2025 14:18
tmeijn pushed a commit to tmeijn/dotfiles that referenced this pull request Jun 23, 2025
This MR contains the following updates:

| Package | Update | Change |
|---|---|---|
| [quarylabs/sqruff](https://github.com/quarylabs/sqruff) | patch | `v0.26.6` -> `v0.26.8` |

MR created with the help of [el-capitano/tools/renovate-bot](https://gitlab.com/el-capitano/tools/renovate-bot).

**Proposed changes to behavior should be submitted there as MRs.**

---

### Release Notes

<details>
<summary>quarylabs/sqruff (quarylabs/sqruff)</summary>

### [`v0.26.8`](https://github.com/quarylabs/sqruff/releases/tag/v0.26.8)

[Compare Source](quarylabs/sqruff@v0.26.7...v0.26.8)

#### What's Changed

- ci: improve ci cancellation by [@&#8203;benfdking](https://github.com/benfdking) in quarylabs/sqruff#1666
- fix: fix open vsx release by [@&#8203;benfdking](https://github.com/benfdking) in quarylabs/sqruff#1667
- chore: bump version by [@&#8203;benfdking](https://github.com/benfdking) in quarylabs/sqruff#1668

**Full Changelog**: quarylabs/sqruff@v0.26.7...v0.26.8

### [`v0.26.7`](https://github.com/quarylabs/sqruff/releases/tag/v0.26.7)

[Compare Source](quarylabs/sqruff@v0.26.6...v0.26.7)

#### What's Changed

- fix: lt08 leading comma panic by [@&#8203;benfdking](https://github.com/benfdking) in quarylabs/sqruff#1585
- chore: bump typescript-eslint from 8.33.1 to 8.34.0 by [@&#8203;dependabot](https://github.com/dependabot) in quarylabs/sqruff#1649
- chore: bump [@&#8203;types/react](https://github.com/types/react) from 19.1.6 to 19.1.8 by [@&#8203;dependabot](https://github.com/dependabot) in quarylabs/sqruff#1651
- chore: bump clap from 4.5.39 to 4.5.40 by [@&#8203;dependabot](https://github.com/dependabot) in quarylabs/sqruff#1656
- chore: bump pyo3 from 0.25.0 to 0.25.1 by [@&#8203;dependabot](https://github.com/dependabot) in quarylabs/sqruff#1654
- chore: bump react-resizable-panels from 3.0.2 to 3.0.3 by [@&#8203;dependabot](https://github.com/dependabot) in quarylabs/sqruff#1653
- chore: bump [@&#8203;playwright/test](https://github.com/playwright/test) from 1.52.0 to 1.53.0 by [@&#8203;dependabot](https://github.com/dependabot) in quarylabs/sqruff#1650
- chore: bump serde\_with from 3.12.0 to 3.13.0 by [@&#8203;dependabot](https://github.com/dependabot) in quarylabs/sqruff#1655
- chore: bump actions/attest-build-provenance from 2.3.0 to 2.4.0 by [@&#8203;dependabot](https://github.com/dependabot) in quarylabs/sqruff#1647
- chore: bump stefanzweifel/git-auto-commit-action from 5.2.0 to 6.0.1 by [@&#8203;dependabot](https://github.com/dependabot) in quarylabs/sqruff#1648
- chore: tailwind update by [@&#8203;benfdking](https://github.com/benfdking) in quarylabs/sqruff#1641
- chore: remove jemalloc by [@&#8203;benfdking](https://github.com/benfdking) in quarylabs/sqruff#1659
- feat(clickhouse): add distinct on functionality by [@&#8203;benfdking](https://github.com/benfdking) in quarylabs/sqruff#1660
- chore: bump tailwindcss from 3.4.17 to 4.1.10 by [@&#8203;dependabot](https://github.com/dependabot) in quarylabs/sqruff#1652
- refactor(rules): extract crawl logic into standalone functions by [@&#8203;gvozdvmozgu](https://github.com/gvozdvmozgu) in quarylabs/sqruff#1559
- chore: update cargo deps by [@&#8203;benfdking](https://github.com/benfdking) in quarylabs/sqruff#1662
- chore: update node dependencies by [@&#8203;benfdking](https://github.com/benfdking) in quarylabs/sqruff#1663
- ci: deploy extension to vsx by [@&#8203;benfdking](https://github.com/benfdking) in quarylabs/sqruff#1661
- chore: bump package version by [@&#8203;benfdking](https://github.com/benfdking) in quarylabs/sqruff#1665

**Full Changelog**: quarylabs/sqruff@v0.26.6...v0.26.7

</details>

---

### Configuration

📅 **Schedule**: Branch creation - At any time (no schedule defined), Automerge - At any time (no schedule defined).

🚦 **Automerge**: Enabled.

♻ **Rebasing**: Whenever MR is behind base branch, or you tick the rebase/retry checkbox.

🔕 **Ignore**: Close this MR and you won't be reminded about this update again.

---

 - [ ] <!-- rebase-check -->If you want to rebase/retry this MR, check this box

---

This MR has been generated by [Renovate Bot](https://github.com/renovatebot/renovate).
<!--renovate-debug:eyJjcmVhdGVkSW5WZXIiOiI0MC42Mi4xIiwidXBkYXRlZEluVmVyIjoiNDAuNjIuMSIsInRhcmdldEJyYW5jaCI6Im1haW4iLCJsYWJlbHMiOlsiUmVub3ZhdGUgQm90Il19-->
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

2 participants