From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mail-12-ewr.dyndns.com (mxout-102-ewr.mailhop.org [216.146.33.102]) by lists.bufferbloat.net (Postfix) with ESMTP id 987102E04AE for ; Mon, 18 Apr 2011 07:42:15 -0700 (PDT) Received: from scan-11-ewr.mailhop.org (scan-11-ewr.local [10.0.141.229]) by mail-12-ewr.dyndns.com (Postfix) with ESMTP id 3DEED931691 for ; Mon, 18 Apr 2011 14:42:14 +0000 (UTC) X-Spam-Score: 0.0 () X-Mail-Handler: MailHop by DynDNS X-Originating-IP: 149.20.54.64 Received: from mainmail.teklibre.com (toutatis.isc.org [149.20.54.64]) by mail-12-ewr.dyndns.com (Postfix) with ESMTP id D964D93150B for ; Mon, 18 Apr 2011 14:42:11 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by mainmail.teklibre.com (Postfix) with ESMTP id 2B57312B74A; Mon, 18 Apr 2011 08:16:44 -0700 (PDT) Received: from mainmail.teklibre.com ([127.0.0.1]) by localhost (toutatis.sql1.isc.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id aC50kFEftMak; Mon, 18 Apr 2011 08:16:44 -0700 (PDT) Received: from [192.168.1.4] (c-68-39-173-20.hsd1.nj.comcast.net [68.39.173.20]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client did not present a certificate) (Authenticated sender: d) by mainmail.teklibre.com (Postfix) with ESMTPSA id 5330D12B6AB; Mon, 18 Apr 2011 08:16:43 -0700 (PDT) Message-ID: <4DAC4DBF.4010605@taht.net> Date: Mon, 18 Apr 2011 08:42:07 -0600 From: Dave Taht User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.14) Gecko/20110223 Thunderbird/3.1.8 MIME-Version: 1.0 To: Nick Feamster References: <27196F99-CB9E-4963-8AA9-71A66B567B69@cc.gatech.edu> <4DAC2C03.2060502@taht.net> <4DAC329E.3040603@taht.net> <34F36110-1468-4ADC-816E-48D869E76DA2@cc.gatech.edu> <7BE6B850-3406-4023-A721-FC51C62AD53D@cc.gatech.edu> In-Reply-To: <7BE6B850-3406-4023-A721-FC51C62AD53D@cc.gatech.edu> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cc: hndr@lists.pixilab.org, bismark-devel@lists.bufferbloat.net, abhishekjain95@gmail.com Subject: Re: [Bismark-devel] [Hndr] Dates are really tricky!! X-BeenThere: bismark-devel@lists.bufferbloat.net X-Mailman-Version: 2.1.13 Precedence: list List-Id: BISMark related software development List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 18 Apr 2011 14:42:15 -0000 On 04/18/2011 08:39 AM, Nick Feamster wrote: > On Apr 18, 2011, at 10:37 AM, Srikanth Sundaresan wrote: > >> On Apr 18, 2011, at 10:11 AM, Nick Feamster wrote: >> >>> I like the idea of generating summary tables per day. That would _really_ speed things up, I think, and most people probably are just looking at the most recent queries by default. Is this in the bug database yet? I'll be happy to file it. :-) Who is working on this part? >> Dave and I discussed this when he was visiting. I'm still not fully convinced that summary tables are the way to go unless we know exactly what we want. Defining exactly what you want is a good idea. :) I do note that the usage pattern by timezone thing is rather important, and very hard to do unless that data is captured about the device(s). > Cool. Let's discuss at tomorrow's meeting? > I can dial in if desired. 12? > It would be nice if we could do something that made the tables faster in one way or another (whether it means splitting by month, or by day). > > -Nick