From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from eggs.gnu.org ([2001:4830:134:3::10]:35115) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1dqaVl-0006Ue-PS for guix-patches@gnu.org; Sat, 09 Sep 2017 03:49:06 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1dqaVi-0004XY-Mx for guix-patches@gnu.org; Sat, 09 Sep 2017 03:49:05 -0400 Received: from debbugs.gnu.org ([208.118.235.43]:48117) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1dqaVi-0004XU-J8 for guix-patches@gnu.org; Sat, 09 Sep 2017 03:49:02 -0400 Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1dqaVi-0003vI-8I for guix-patches@gnu.org; Sat, 09 Sep 2017 03:49:02 -0400 Subject: [bug#27876] [PATCH v2 1/3] cuirass: Store new information in database to prepare new HTTP API integration. Resent-Message-ID: References: <20170730100759.17734-1-m.othacehe@gmail.com> <20170801195124.7030-1-m.othacehe@gmail.com> <87o9ql89lp.fsf@gnu.org> <87pob1m2bk.fsf@gmail.com> <871sngapjy.fsf@gnu.org> From: Mathieu Othacehe Message-ID: <87lglomhxo.fsf@gmail.com> In-reply-to: <871sngapjy.fsf@gnu.org> Date: Sat, 09 Sep 2017 09:48:15 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: guix-patches-bounces+kyle=kyleam.com@gnu.org Sender: "Guix-patches" To: Ludovic =?UTF-8?Q?Court=C3=A8s?= Cc: 27876-done@debbugs.gnu.org > With an autoincremented index, I suppose we might want to make sure that > ‘db-add-build’ does not add a new entry for a build that’s already in > the table. WDYT? Yes we might, but looking for a build with the same derivation-evaluation-outputs before each build insertion will be an expensive operation (now that this tuple is no longer the primary key). Mathieu