[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: postgresql vs sqlite for Cuirass (was Re: Hackathon: Mumi and Cuiras
From: |
Ludovic Courtès |
Subject: |
Re: postgresql vs sqlite for Cuirass (was Re: Hackathon: Mumi and Cuirass) |
Date: |
Tue, 21 May 2019 12:19:31 +0200 |
User-agent: |
Gnus/5.13 (Gnus v5.13) Emacs/26.2 (gnu/linux) |
Hi,
Ricardo Wurmus <address@hidden> skribis:
> Gábor Boskovits <address@hidden> 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’.