On Mon, Aug 25, 2014 at 4:20 PM, Raphael Hertzog <hert...@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 -- To UNSUBSCRIBE, email to debian-qa-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org Archive: https://lists.debian.org/CAL6k_AzrMfXcDhkAFNQOmetH5C=eL-Zb9=abjatt4tk178o...@mail.gmail.com
