New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Run expensive crawlers queries on secondary readonly DB #3280

Closed

skofman1 opened this issue Oct 17, 2016 · 1 comment

Labels

Area: Gallery UI Area: Performance ClosedAs - Duplicate Priority - 1

Contributor

skofman1 commented Oct 17, 2016

Crawlers run expensive queries on Gallery OData V2 endpoint of this form:
The calls are from this form:
http://packages.nuget.org/v1/FeedService.svc/Search()?searchTerm=''&targetFramework='net45'&$filter=IsLatestVersion&$orderby=DownloadCount desc,Id&$skip=30600&$top=30
https://packages.nuget.org/api/v2/Packages?$skip=88500

We suggest to run those queries against a secondary readonly DB to reduce load on primary DB.

skofman1 self-assigned this

skofman1 assigned cristinamanum and unassigned skofman1

skofman1 added Area: Gallery UI Area: Performance Priority - 1 labels

Contributor Author

skofman1 commented Apr 11, 2017

Duplicate of: https://github.com/NuGet/Engineering/issues/245

skofman1 closed this as completed

skofman1 unassigned cristinamanum

skofman1 added the ClosedAs - Duplicate label

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment