[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Outreachy] - Guix Data Service - Set a more informative page title
From: |
Christopher Baines |
Subject: |
Re: [Outreachy] - Guix Data Service - Set a more informative page title |
Date: |
Sat, 24 Apr 2021 12:39:34 +0100 |
User-agent: |
mu4e 1.4.15; emacs 27.1 |
Christopher Baines <mail@cbaines.net> writes:
> The approach I'd recommend is, make yourself a realistic
> temp_package_metadata table by populating it with all the
> package_metadata entries for a single revision already in your local
> database. Then construct and try the slow query, and see how long it
> takes, and look at the query plan (run the query with EXPLAIN at the
> start).
Following up on your question on IRC about creating the temporary table,
the code that does this is here [1]. I wouldn't suggest running the
code, just the same SQL it uses, and use relevant values for
temp-table-name and table-name that are appropriate for the
package_metadata table.
1:
https://git.savannah.gnu.org/cgit/guix/data-service.git/tree/guix-data-service/model/utils.scm#n313
signature.asc
Description: PGP signature
- Re: [Outreachy] - Guix Data Service - Set a more informative page title, (continued)
- Re: [Outreachy] - Guix Data Service - Set a more informative page title, Canan Talayhan, 2021/04/16
- Re: [Outreachy] - Guix Data Service - Set a more informative page title, Christopher Baines, 2021/04/16
- Re: [Outreachy] - Guix Data Service - Set a more informative page title, Canan Talayhan, 2021/04/18
- Re: [Outreachy] - Guix Data Service - Set a more informative page title, Christopher Baines, 2021/04/18
- Re: [Outreachy] - Guix Data Service - Set a more informative page title, Canan Talayhan, 2021/04/18
- Re: [Outreachy] - Guix Data Service - Set a more informative page title, Christopher Baines, 2021/04/19
- Re: [Outreachy] - Guix Data Service - Set a more informative page title, Canan Talayhan, 2021/04/21
- Re: [Outreachy] - Guix Data Service - Set a more informative page title, Christopher Baines, 2021/04/22
- Re: [Outreachy] - Guix Data Service - Set a more informative page title, Canan Talayhan, 2021/04/23
- Re: [Outreachy] - Guix Data Service - Set a more informative page title, Christopher Baines, 2021/04/23
- Re: [Outreachy] - Guix Data Service - Set a more informative page title,
Christopher Baines <=
- Re: [Outreachy] - Guix Data Service - Set a more informative page title, Canan Talayhan, 2021/04/24
- Re: [Outreachy] - Guix Data Service - Set a more informative page title, Christopher Baines, 2021/04/24