Skip to content

Avoid realizing the entire solution snapshot in the Sql layer.#48678

Merged
3 commits merged intodotnet:masterfrom
CyrusNajmabadi:solutionPerf
Oct 16, 2020
Merged

Avoid realizing the entire solution snapshot in the Sql layer.#48678
3 commits merged intodotnet:masterfrom
CyrusNajmabadi:solutionPerf

Conversation

@CyrusNajmabadi
Copy link
Contributor

Fixes #48597.

All the data we need is in the realized green snapshot tree. So we can just walk that instead of forcing the creation of the entire red tree.

@CyrusNajmabadi CyrusNajmabadi requested a review from a team as a code owner October 16, 2020 16:15
@Dotnet-GitSync-Bot

This comment has been minimized.

Copy link
Contributor

@sharwell sharwell left a comment

Choose a reason for hiding this comment

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

Clever. Consider filing a follow-up issue to track optimizations in the public API surface since there is certainly some low-hanging fruit here.

@CyrusNajmabadi
Copy link
Contributor Author

Clever. Consider filing a follow-up issue to track optimizations in the public API surface since there is certainly some low-hanging fruit here.

Will do!

@ghost
Copy link

ghost commented Oct 16, 2020

Hello @CyrusNajmabadi!

Because this pull request has the auto-merge label, I will be glad to assist with helping to merge this pull request once all check-in policies pass.

p.s. you can customize the way I help with merging this pull request, such as holding this pull request until a specific person approves. Simply @mention me (@msftbot) and give me an instruction to get started! Learn more here.

Copy link

@ghost ghost left a comment

Choose a reason for hiding this comment

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

Auto-approval

Copy link
Member

@jasonmalinowski jasonmalinowski left a comment

Choose a reason for hiding this comment

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

Looks good, but I agree with @sharwell that we probably should track some work here. We already have a DocumentIds/ProjectIds collection exposed when you need just the IDs; it might be easy to make a DocumentAttributes or ProjectAttributes that exposes just the attributes but, and that we could do nearly allocation free.

@ghost ghost merged commit 357eb7a into dotnet:master Oct 16, 2020
@ghost ghost added this to the Next milestone Oct 16, 2020
@CyrusNajmabadi CyrusNajmabadi deleted the solutionPerf branch October 16, 2020 20:38
@allisonchou allisonchou modified the milestones: Next, 16.9.P2 Nov 24, 2020
This pull request was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Projects

None yet

Development

Successfully merging this pull request may close these issues.

SQLitePersistentStorage.BulkPopulateProjectIds consumes significant CPU in large solutions

5 participants