From mboxrd@z Thu Jan 1 00:00:00 1970 From: =?utf-8?Q?Ludovic_Court=C3=A8s?= Subject: Re: postgresql vs sqlite for Cuirass (was Re: Hackathon: Mumi and Cuirass) Date: Tue, 21 May 2019 12:19:31 +0200 Message-ID: <87imu43ya4.fsf@gnu.org> References: <875zqrgqlf.fsf@elephly.net> <20190506225554.43e93d0d@alma-ubu> <87imuabhsw.fsf@roquette.mug.biscuolo.net> <87h89tdypj.fsf@elephly.net> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Return-path: Received: from eggs.gnu.org ([209.51.188.92]:49877) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1hT1rq-0004qf-Hm for guix-devel@gnu.org; Tue, 21 May 2019 06:19:35 -0400 In-Reply-To: <87h89tdypj.fsf@elephly.net> (Ricardo Wurmus's message of "Fri, 17 May 2019 14:58:48 +0200") List-Id: "Development of GNU Guix and the GNU System distribution." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: guix-devel-bounces+gcggd-guix-devel=m.gmane.org@gnu.org Sender: "Guix-devel" To: Ricardo Wurmus Cc: Guix-devel Hi, Ricardo Wurmus skribis: > G=C3=A1bor Boskovits writes: > >> Currently the database response times on sqlite are not acceptable. >> Any suggestions to overcome this would be appreciated. > > I started playing with Cuirass again to add a search feature and while > looking through the code I was astonished to see how complicated the SQL > queries seem. > > Are there any queries in particular that you consider not acceptable? At the Guix Days, I think there was consensus that the big query of =E2=80=98db-get-builds=E2=80=99, although it was initially introduced for p= erformance reasons, was =E2=80=9Cproblematic.=E2=80=9D I=E2=80=99m sure G=C3=A1bor, B= j=C3=B6rn, or Danny would have a clearer explanation. :-) Ludo=E2=80=99.