The slowest bit of that is in SourcePackageRecordView.built_packages, where it's pulling back well over 3000 very wide rows and then spending 3.5 seconds materialising it all into Python for the sake of two columns. (And then due to a bug in sourcepackagepublishinghistory-listing-archive-extra.pt it tries to do it twice.)
We'd have to add a new method to SPPH with a more focused query, but it shouldn't be too hard to make this a lot faster.
The slowest bit of that is in SourcePackageRe cordView. built_packages, where it's pulling back well over 3000 very wide rows and then spending 3.5 seconds materialising it all into Python for the sake of two columns. (And then due to a bug in sourcepackagepu blishinghistory -listing- archive- extra.pt it tries to do it twice.)
We'd have to add a new method to SPPH with a more focused query, but it shouldn't be too hard to make this a lot faster.