[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Cuirass logo - artwork.
From: |
Pierre Neidhardt |
Subject: |
Re: Cuirass logo - artwork. |
Date: |
Sat, 09 Jan 2021 11:13:54 +0100 |
Mathieu Othacehe <othacehe@gnu.org> writes:
> At first I thought that all the performance issues we had were caused by
> unoptimized SQL queries. Turns out it was only half of the problem.
>
> As we have multiple processes accessing the database (cuirass,
> cuirass-web, cuirass-send-events and now remote-server), we are falling
> into the architecture model that is very badly supported by SQLite: many
> readers and many readers across several processes[1].
>
> I also noticed that SQLite doesn't handle I/O pressure on the hard drive
> the database is sitting on. I had to mount the database file on a tmpfs
> directory to get around this issue[2].
>
> Finally, SQLite doesn't offer any real monitoring solution, requires
> periodical vacuuming and is really hard to configure[3].
>
> As stated on SQLite website: "SQLite does not compete with client/server
> databases. SQLite competes with fopen()."
>
> I've been running Cuirass using a PostgreSQL database, and without any
> particular tuning everything works smooth, which makes me regret to have
> waited so long to leap the breach.
>
> Thanks for you interest,
Very interesting, thanks for sharing your experience. Worth a blog post
in my opinion ;)
Cheers!
signature.asc
Description: PGP signature
- Cuirass logo - artwork., Mathieu Othacehe, 2021/01/08
- Re: Cuirass logo - artwork., Pierre Neidhardt, 2021/01/08
- Re: Cuirass logo - artwork., Jonathan Brielmaier, 2021/01/08
- Re: Cuirass logo - artwork., Luis Felipe, 2021/01/08
- Re: Cuirass logo - artwork., Luis Felipe, 2021/01/09
- Re: Cuirass logo - artwork., Tobias Geerinckx-Rice, 2021/01/10
- Re: Cuirass logo - artwork., Luis Felipe, 2021/01/10
- Re: Cuirass logo - artwork., Mathieu Othacehe, 2021/01/12
- Re: Cuirass logo - artwork., Luis Felipe, 2021/01/14
- Re: Cuirass logo - artwork., Tobias Geerinckx-Rice, 2021/01/14