From mboxrd@z Thu Jan 1 00:00:00 1970 From: Ricardo Wurmus Subject: Re: postgresql vs sqlite for Cuirass (was Re: Hackathon: Mumi and Cuirass) Date: Fri, 17 May 2019 14:58:48 +0200 Message-ID: <87h89tdypj.fsf@elephly.net> References: <875zqrgqlf.fsf@elephly.net> <20190506225554.43e93d0d@alma-ubu> <87imuabhsw.fsf@roquette.mug.biscuolo.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]:54289) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1hSSlI-0005IR-FF for guix-devel@gnu.org; Sun, 19 May 2019 16:50:29 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1hSSlG-0002Ej-9t for guix-devel@gnu.org; Sun, 19 May 2019 16:50:27 -0400 Received: from sender4-of-o53.zoho.com ([136.143.188.53]:21313) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:32) (Exim 4.71) (envelope-from ) id 1hSSlF-00028t-M4 for guix-devel@gnu.org; Sun, 19 May 2019 16:50:26 -0400 In-reply-to: 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: =?utf-8?Q?G=C3=A1bor?= Boskovits Cc: Guix-devel 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? --=20 Ricardo