From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from pigeon.gentoo.org ([208.92.234.80] helo=lists.gentoo.org) by finch.gentoo.org with esmtp (Exim 4.60) (envelope-from ) id 1NzzCI-0008I5-BR for garchives@archives.gentoo.org; Thu, 08 Apr 2010 21:23:34 +0000 Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 2B002E07FE; Thu, 8 Apr 2010 21:23:29 +0000 (UTC) Received: from smtp.gentoo.org (smtp.gentoo.org [140.211.166.183]) by pigeon.gentoo.org (Postfix) with ESMTP id C3ED6E079C for ; Thu, 8 Apr 2010 21:22:51 +0000 (UTC) Received: from [192.168.0.3] (e179000161.adsl.alicedsl.de [85.179.0.161]) (using TLSv1 with cipher DHE-RSA-CAMELLIA256-SHA (256/256 bits)) (No client certificate requested) by smtp.gentoo.org (Postfix) with ESMTP id 143D01B4019 for ; Thu, 8 Apr 2010 21:22:50 +0000 (UTC) Message-ID: <4BBE4922.4040400@gentoo.org> Date: Thu, 08 Apr 2010 23:22:42 +0200 From: Sebastian Pipping User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.1.8) Gecko/20100331 Thunderbird/3.0.3 Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-dev@lists.gentoo.org Reply-to: gentoo-dev@lists.gentoo.org MIME-Version: 1.0 To: gentoo-dev@lists.gentoo.org Subject: Re: [gentoo-dev] [Gentoo Pheonix] Heartbeat team force References: <4BB7C02D.7090008@gentoo.org> <4BBC6A6B.5080804@gentoo.org> In-Reply-To: X-Enigmail-Version: 1.0.1 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Archives-Salt: 5a3efb05-4094-45c4-8a37-012fdd41a07d X-Archives-Hash: d10e1cd9fc33947c888479ba956cde86 On 04/08/10 21:16, Robin H. Johnson wrote: > On Wed, Apr 07, 2010 at 01:20:11PM +0200, Sebastian Pipping wrote: >> Current results >> =============== >> Bug load per developer >> ---------------------- >> http://dev.gentoo.org/~sping/bug-heartbeat/report--bug-count-by-person.html > What's the actual math that you're using (it wasn't clear in your repo). let me try in python: load[dev] = bugs[dev] \ + reduce(sum, [bugs(h)/members(h) for h in herds[dev]]) it's personal bugs plus a fraction of all herds you're in. makes sense? >> - Pulling XML out of Bugzilla does no longer >> feel right with this amount of data: >> it's 15,000 open bugs that need to be >> refreshed periodically in chunks of 100 bugs >> (Bugzilla's limit) each. That's 150 request >> for a full sync. How can that be improved? > Lets talk more about what queries you're using, and we can probably work > something out. speaking of queries would limit me in what i may ask the data in the future. i have a full dump on open bugs more or less so i can ask them whatever i like. it's more flexible to me and makes much easier code than SQL stuff would. i guess that doesn't make it easier? sebastian