Return-Path: Delivered-To: apmail-continuum-dev-archive@www.apache.org Received: (qmail 58105 invoked from network); 28 Mar 2008 16:51:28 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 28 Mar 2008 16:51:28 -0000 Received: (qmail 19412 invoked by uid 500); 28 Mar 2008 16:51:27 -0000 Delivered-To: apmail-continuum-dev-archive@continuum.apache.org Received: (qmail 19378 invoked by uid 500); 28 Mar 2008 16:51:27 -0000 Mailing-List: contact dev-help@continuum.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@continuum.apache.org Delivered-To: mailing list dev@continuum.apache.org Received: (qmail 19368 invoked by uid 99); 28 Mar 2008 16:51:27 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 28 Mar 2008 09:51:27 -0700 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of emmanuel.venisse@gmail.com designates 209.85.146.183 as permitted sender) Received: from [209.85.146.183] (HELO wa-out-1112.google.com) (209.85.146.183) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 28 Mar 2008 16:50:45 +0000 Received: by wa-out-1112.google.com with SMTP id k22so405036waf.18 for ; Fri, 28 Mar 2008 09:50:56 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; bh=ySgR2ArG8qG/pb3DzfAmxiwhpAh7qY0D1tPAxD6lbCI=; b=NphRRS0TnZ4AVuB9ogdKUkaQwCq+h1zOb6Gp/B+z2Rqtfy46XlKMmfFwZCmRj564cnhGRggSF1zLhHuMX3BOEwcCMWEGQ5D5P/tXcRO2R/9N+yRBgpvrYJ4/L4pg29KsDGW/MHF7U9CIKKFfwW4i9s9RxUGNrCfY2V4fcdpKnMw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=bp1ABLtUIXavjdMcsJna+S/PA3xd7YC9PziA8t2tZIklVhg8/3BD3peaCXSCxMfHHjjzIgyrW5TevpfFUAO1iNllZIpES9xIICIaUUP3Gsf6sTueYR1Cym3ix4XXVr1KRR4c7pVqfdhN3B8L0lEVc1QDQpkRABvTaWKndsd5okQ= Received: by 10.114.27.20 with SMTP id a20mr4128663waa.101.1206723056616; Fri, 28 Mar 2008 09:50:56 -0700 (PDT) Received: by 10.114.73.6 with HTTP; Fri, 28 Mar 2008 09:50:56 -0700 (PDT) Message-ID: Date: Fri, 28 Mar 2008 17:50:56 +0100 From: "Emmanuel Venisse" To: dev@continuum.apache.org Subject: Re: New feature: Scheduled purge of old build results In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_33340_14998190.1206723056617" References: X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_33340_14998190.1206723056617 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline On Fri, Mar 28, 2008 at 4:44 PM, Wendy Smoak wrote: > On Fri, Mar 28, 2008 at 8:31 AM, Emmanuel Venisse > wrote: > > >> URL: http://jira.codehaus.org/browse/CONTINUUM-1696 > > > We must discuss about it. > > Okay. :) Do you have a concern about adding this feature, or ... ? > :) I'd want to know what you mean with a purge. If you just delete old build results in the db, I don't think it will be enough. It will be better to keep somewhere (in a file) some datas about deleted build results so they will can be included in some historical graphs when we'll add them. At the same time, I'd like to move build results out of the db because build results use lot of memory with all scm informations. If we want to keep some build results informations in the db for some requests, we need only some basic datas ( start/end dates, duration, build number, state) and dependencies changes. All others informations are statics and we don't need them for requests, only for the build result page. Before to implement the purge, I think it would be better to implement this to save memory. Then the purge process will be: - remove the build result information file - remove the basic build result record in the db - create a new file for the history with data that was in the record. WDYT? Emmanuel ------=_Part_33340_14998190.1206723056617--