Re: postgresql vs sqlite for Cuirass (was Re: Hackathon: Mumi and Cuirass)

[Ludovic Courtès]

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’.