all messages for Guix-related lists mirrored at yhetil.org
 help / color / mirror / code / Atom feed
From: "Ludovic Courtès" <ludo@gnu.org>
To: Ricardo Wurmus <rekado@elephly.net>
Cc: Guix-devel <guix-devel@gnu.org>
Subject: Re: postgresql vs sqlite for Cuirass (was Re: Hackathon: Mumi and Cuirass)
Date: Tue, 21 May 2019 12:19:31 +0200	[thread overview]
Message-ID: <87imu43ya4.fsf@gnu.org> (raw)
In-Reply-To: <87h89tdypj.fsf@elephly.net> (Ricardo Wurmus's message of "Fri, 17 May 2019 14:58:48 +0200")

Hi,

Ricardo Wurmus <rekado@elephly.net> skribis:

> Gábor Boskovits <boskovits@gmail.com> 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
‘db-get-builds’, although it was initially introduced for performance
reasons, was “problematic.”  I’m sure Gábor, Björn, or Danny would have
a clearer explanation.  :-)

Ludo’.

      reply	other threads:[~2019-05-21 10:19 UTC|newest]

Thread overview: 11+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2019-05-03 21:45 Hackathon: Mumi and Cuirass Ricardo Wurmus
2019-05-04  7:19 ` Christopher Baines
2019-05-06 20:55 ` Björn Höfling
2019-05-06 22:10   ` Christopher Baines
2019-05-07  5:19   ` Ricardo Wurmus
2019-05-16 14:22   ` postgresql vs sqlite for Cuirass (was Re: Hackathon: Mumi and Cuirass) Giovanni Biscuolo
2019-05-17  8:26     ` Gábor Boskovits
2019-05-17 10:42       ` Aljosha Papsch
2019-05-17 20:29         ` Ricardo Wurmus
2019-05-17 12:58       ` Ricardo Wurmus
2019-05-21 10:19         ` Ludovic Courtès [this message]

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=87imu43ya4.fsf@gnu.org \
    --to=ludo@gnu.org \
    --cc=guix-devel@gnu.org \
    --cc=rekado@elephly.net \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body. 
Code repositories for project(s) associated with this external index

	https://git.savannah.gnu.org/cgit/guix.git

This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.