Skip to content

Optimize out unnecessary joins when querying archetypes#3377

Merged
teh-cmc merged 6 commits intomainfrom
cmc/dont_join_if_you_dont_have_to
Sep 20, 2023
Merged

Optimize out unnecessary joins when querying archetypes#3377
teh-cmc merged 6 commits intomainfrom
cmc/dont_join_if_you_dont_have_to

Conversation

@teh-cmc
Copy link
Copy Markdown
Contributor

@teh-cmc teh-cmc commented Sep 20, 2023

What the title says; see the commits for details, it's pretty trivial.

Going from a ~62ms space view build time to ~40ms in the OPF example, so pretty nice gains overall.

OPF, before:
image (17)

OPF, after:
image

What

Checklist

@teh-cmc teh-cmc added 📺 re_viewer affects re_viewer itself 📉 performance Optimization, memory use, etc labels Sep 20, 2023
@teh-cmc teh-cmc marked this pull request as ready for review September 20, 2023 08:39
Copy link
Copy Markdown
Member

@emilk emilk left a comment

Choose a reason for hiding this comment

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

Wow, that was easy 🥳

@teh-cmc
Copy link
Copy Markdown
Contributor Author

teh-cmc commented Sep 20, 2023

I'm seeing more low-hanging fruit in that function... gimme a sec... 👀

@teh-cmc
Copy link
Copy Markdown
Contributor Author

teh-cmc commented Sep 20, 2023

Alright, grabbed all the milliseconds I could: 62ms -> 40ms to build the point3d view in OPF.

Now let's see how all that behaves with the new mesh archetype.

@teh-cmc
Copy link
Copy Markdown
Contributor Author

teh-cmc commented Sep 20, 2023

@teh-cmc teh-cmc force-pushed the cmc/dont_join_if_you_dont_have_to branch from f40d3a3 to b0410c8 Compare September 20, 2023 11:15
@teh-cmc teh-cmc merged commit 84581b7 into main Sep 20, 2023
@teh-cmc teh-cmc deleted the cmc/dont_join_if_you_dont_have_to branch September 20, 2023 12:57
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

📉 performance Optimization, memory use, etc 📺 re_viewer affects re_viewer itself

Projects

None yet

Development

Successfully merging this pull request may close these issues.

Optimize out unnecessary joins across autogenerated instance keys

2 participants