Ancestors

Toot

Written by Vik Fearing on 2024-12-08 at 15:42

I just completed "Bridge Repair" - Day 7 - Advent of Code 2024 #AdventOfCode https://adventofcode.com/2024/day/7

https://github.com/xocolatl/advent-of-code/blob/master/2024/dec07.sql

=> More informations about this toot | More toots from xocolatl@mastodon.social

Descendants

Written by docteurklein on 2024-12-08 at 16:12

@xocolatl nice :) does it run fast? Just curious because I saw people posting some numbers today

=> More informations about this toot | More toots from docteurklein@mastodon.social

Written by Vik Fearing on 2024-12-08 at 16:27

@docteurklein

Considering the fact that SQL is not even remotely the right tool for the job, it is kind of slow.

350ms for the first star, and 15s for the second star.

=> More informations about this toot | More toots from xocolatl@mastodon.social

Written by Matthijs on 2024-12-08 at 19:18

@xocolatl @docteurklein You might be able to speed it up a little by avoiding the string concatenation.

=> More informations about this toot | More toots from zr40@zr40.nl

Written by Vik Fearing on 2024-12-08 at 19:33

@zr40 @docteurklein

Probably.

=> More informations about this toot | More toots from xocolatl@mastodon.social

Written by Matthijs on 2024-12-08 at 22:27

@xocolatl @docteurklein Applying the optimization I was thinking of to your solution, runtime actually increases from 18s to 82s on my system. I did not expect that.

=> More informations about this toot | More toots from zr40@zr40.nl