Skip to content

geo: minor performance improvement for looping over edges#62832

Merged
craig[bot] merged 1 commit intocockroachdb:masterfrom
andyyang890:num_edges_optimization
Apr 1, 2021
Merged

geo: minor performance improvement for looping over edges#62832
craig[bot] merged 1 commit intocockroachdb:masterfrom
andyyang890:num_edges_optimization

Conversation

@andyyang890
Copy link
Copy Markdown
Collaborator

This patch slightly improves the performance of many
spatial builtins by storing the number of edges used
in the loop conditions of for loops into a variable.
We discovered this was taking a lot of time when
profiling the point-in-polygon optimization.

Release note: None

This patch slightly improves the performance of many
spatial builtins by storing the number of edges used
in the loop conditions of for loops into a variable.
We discovered this was taking a lot of time when
profiling the point-in-polygon optimization.

Release note: None
@andyyang890 andyyang890 requested a review from otan March 30, 2021 22:41
@cockroach-teamcity
Copy link
Copy Markdown
Member

This change is Reviewable

@andyyang890
Copy link
Copy Markdown
Collaborator Author

bors r=otan

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Mar 31, 2021

Build failed (retrying...):

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Mar 31, 2021

Build failed (retrying...):

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Apr 1, 2021

Build succeeded:

@craig craig bot merged commit 41f921d into cockroachdb:master Apr 1, 2021
@andyyang890 andyyang890 deleted the num_edges_optimization branch April 1, 2021 16:34
@knz
Copy link
Copy Markdown
Contributor

knz commented Apr 13, 2021

@andyyang890 is this a candidate for a backport?

@andyyang890
Copy link
Copy Markdown
Collaborator Author

andyyang890 commented Apr 13, 2021

@andyyang890 is this a candidate for a backport?

Yes, good catch, we'll merge it in for 21.1.1

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.

5 participants