archive:+packages timeout

[Robert Collins]

OOPS-1765A1770, OOPS-1765B931, OOPS-1765D2161, OOPS-1765H2115, OOPS-1765L621

Looking at OOPS-1765A1770

Branch: launchpad-rev-11793
Revno: 11793
SQL time: 9134 ms
Non-sql time: 6206 ms
Total time: 15340 ms
Statement Count: 1127

https://launchpad.net/%7Eyavdr/+archive/stable-vdr/+packages?start=0&batch=204

death by queries

An easy 3.2 seconds here:
 Reps Total time Average time Saving Database id Statement
1 360 1881 5 1876 SQL-launchpad-main-slave SELECT PackageBuild.archive, PackageBuild.build_farm_job, PackageBuild.dependencies, PackageBuild.id, PackageBuild.pocket, PackageBuild.upload_log FROM PackageBuild WHERE PackageBuild.id = %s LIMIT 1
2 360 1872 5 1867 SQL-launchpad-main-slave SELECT BuildFarmJob.builder, BuildFarmJob.date_created, BuildFarmJob.date_finished, BuildFarmJob.date_first_dispatched, BuildFarmJob.date_started, BuildFarmJob.failure_count, BuildFarmJob.id, BuildFarmJob.job_type, BuildFarmJob.log, BuildFarmJob.processor, BuildFarmJob.status, BuildFarmJob.virtualized FROM BuildFarmJob WHERE BuildFarmJob.id = %s LIMIT 1
catering for 720 queries.

[Launchpad QA Bot (lpqabot)]

r11856 in stable (http://bazaar.launchpad.net/~launchpad-pqm/launchpad/stable/revision/11856) is part of this bug's fix.

[Robert Collins (lifeless)]

Page still works, OOPS-1770QS10 shows that its still scaling poorly - 415 queries.

[Robert Collins (lifeless)]

key repeated queries:
1 145 236 1 235 SQL-launchpad-main-slave SELECT BuildFarmJob.builder, BuildFarmJob.date_created, BuildFarmJob.date_finished, BuildFarmJob.date_first_dispatched, BuildFarmJob.date_started, BuildFarmJob.failure_count, BuildFarmJob.id, BuildFarmJob.job_type, BuildFarmJob.log, BuildFarmJob.processor, BuildFarmJob.status, BuildFarmJob.virtualized FROM BuildFarmJob WHERE BuildFarmJob.id = %s LIMIT 1
2 145 205 1 204 SQL-launchpad-main-slave SELECT PackageBuild.archive, PackageBuild.build_farm_job, PackageBuild.dependencies, PackageBuild.id, PackageBuild.pocket, PackageBuild.upload_log FROM PackageBuild WHERE PackageBuild.id = %s LIMIT 1
3 80 50 0 50 SQL-launchpad-main-slave SELECT SourcePackageName.id, SourcePackageName.name FROM SourcePackageName WHERE SourcePackageName.id = %s LIMIT 1

[Robert Collins (lifeless)]

So the reference page is Just Working now. Closing (and will open a new one for further work - its down to'At least 1003 queries/external actions issued in 14.48 seconds') which is still pretty close to terrible.