From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mail-iy0-f171.google.com (mail-iy0-f171.google.com [209.85.210.171]) (using TLSv1 with cipher RC4-SHA (128/128 bits)) (Client CN "smtp.gmail.com", Issuer "Google Internet Authority" (verified OK)) by huchra.bufferbloat.net (Postfix) with ESMTPS id 8660C2011BF for ; Sat, 14 May 2011 22:38:11 -0700 (PDT) Received: by iyi20 with SMTP id 20so4618077iyi.16 for ; Sat, 14 May 2011 22:47:12 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:date:message-id:subject:from:to :content-type; bh=+tD7wqJFEL0GwpxFaPla+kJOwHQi5tenS9x3yeQglI0=; b=oPVm59f9OmXZ73hdczHI5OsaUzgub/nKoBcXdJIfzVuWUTjT1SEjjCaDAnAe24cMhM C6lpbQd5AARZWLrWU9dEU7BFCLjAb6S8+rvC2bAGmUIrNanyPyPrsHyF9K7kQNwnoxdm C4Bb+R835VZfa3jOJqqWUeFceXV4hCPZt0754= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=wmV8j3WgKg08AOe3c9lq5IHuCW05lrbyTT7shBlUcIEKL7uaVUFPjChxKC5eLJ0U8B G3n6kjutqm3Ms/D/WPg2gDdWZ6hst2EiC2JCyKioMbSo6cNp3h5GW1GnBoL9pOkrZAOq 0/4zF+hLJGrXXNDGvg9+LrwCVYFASPwkqKS6o= MIME-Version: 1.0 Received: by 10.231.188.140 with SMTP id da12mr2242375ibb.131.1305438432363; Sat, 14 May 2011 22:47:12 -0700 (PDT) Received: by 10.231.31.201 with HTTP; Sat, 14 May 2011 22:47:12 -0700 (PDT) Date: Sat, 14 May 2011 23:47:12 -0600 Message-ID: From: Dave Taht To: bismark-devel@lists.bufferbloat.net Content-Type: multipart/alternative; boundary=001636c925f20985cb04a34a12e3 Subject: [Bismark-devel] looking over the db 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: Sun, 15 May 2011 05:38:11 -0000 --001636c925f20985cb04a34a12e3 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable I've had a chance to look at and review the database with the tests in it. = I figure it can be sped up by several orders of magnitude, but lacking exampl= e queries, (please supply some) I do not know what features can drop or add. Qs: 0) Why are timestamps not native types? 1) What is the use of the id field in various tests? the timestamp + macadd= r should be sufficient. 2) In other places the id field could be replaced with a sha1 hash, thus making the overall design fully distributable (multiple databases) --=20 Dave T=E4ht SKYPE: davetaht US Tel: 1-239-829-5608 http://the-edge.blogspot.com --001636c925f20985cb04a34a12e3 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable I've had a chance to look at and review the database with the tests in= =20 it. I figure it can be sped up by several orders of magnitude, but=20 lacking example queries, (please supply some) I do not know what=20 features=A0 can drop or add. Qs: 0) Why are timestamps not native types?
1) What is the use of the id field in various tests? the timestamp + macadd= r should be sufficient.

2) In other places the id fiel= d could be replaced with a sha1 hash, thus making the overall design fully = distributable (multiple databases)
--
Dave T=E4ht
SKYPE: davetaht
US Tel: 1-239-829-5608
http://the-edge.blogspo= t.com
--001636c925f20985cb04a34a12e3--