Tony Q.
Tony Q.
If I wanna look into the issue and contribute a PR, where shall I start? Can you give me a page entry for this?
> .Where(p => p.PackageStatusKey == PackageStatus.Available) .OrderByDescending(p => p.PackageRegistration.DownloadCount) I guess there could be some potential issues here - Does PackageStatusKey column have physical Indexing or logical indexing - Does...
Even if the SQL is slow, we should add a page cache or a result cache to this page so that it can return the result immediately.
@JonDouglas Can we put this fix in the [next sprint](https://github.com/NuGet/NuGetGallery/issues?q=is%3Aissue%20state%3Aopen%20milestone%3A%22Sprint%202025-05%22)? Or any upcoming sprint?
> We are the DBA :) Wow, don't tell me you are also project managers |o|
So what do you think? Do you wanna me change the EF migration code or you guys will do tricky indexing operation on your SQL Server?
How many data are in the local database? I'm not sure if I can reproduce the issue with little data since it's SQL performance issue. To be honest, I haven't...
localDB is usually SQL Server Express. I'm not sure if it's enough to do performance test. I prefer SQL Server.
> You could write a script to upload many thousands of random package IDs via the push API or insert data directly. This could take a few days if I...