Bug#756752: tracker.debian.org: Access package screenshots

[Andrew Starr-Bochicchio <a.starr.b@gmail.com>]

On Mon, Aug 25, 2014 at 4:20 PM, Raphael Hertzog <hertzog@debian.org> wrote:
> On Mon, 25 Aug 2014, Andrew Starr-Bochicchio wrote:
>> The attached patch adds links to screenshots.debian.net when they
>> exist. It's slower that I'd like.
>
> Some ideas to improve it:
> 1/ use a transaction (protect most of execute in "with
> transaction.atomic():")
> 2/ use bulk insert in Django (and bulk delete first in the transaction)
> https://docs.djangoproject.com/en/1.6/ref/models/querysets/#django.db.models.query.QuerySet.bulk_create
>
> See UpdatePackageBugStats.update_source_and_pseudo_bugs() for an example.
>
> Performance is rather important. We're looking to have very regular runs
> of most tasks.

Hi Raphael,

Thanks for the feedback. Where do you think it is best to store this
information? The problem is that I can't use bulk delete for a
specific PackageExtractedInfo key and doing it to the object obviously
destroys other info we want to keep. Or am I just missing something?

Thanks,

-- Andrew Starr-Bochicchio

   Ubuntu Developer <https://launchpad.net/~andrewsomething>
   Debian Developer <http://qa.debian.org/developer.php?login=asb>
   PGP/GPG Key ID: D53FDCB1