archive:+index timeout

OOPS-1788D223

Branch: launchpad-rev-11927
Revno: 11927
SQL time: 11263 ms
Non-sql time: 5447 ms
Total time: 16710 ms
Statement Count: 345

https://launchpad.net/%7Exorg-edgers/+archive/ppa/+index

Looks like Binary package scaling now.

1 146 2935 20 2915 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 146 1004 6 998 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
are the two highest frequency repeats. PLus there are many slightly different 400ms queries.