1092 slow backend logs function

ewan-escience commented 7 months ago

Faster backend log browsing

Changes proposed in this pull request:

Change the return type of slug_from_log_reference() to be a VARCHAR instead of a TABLE, to allow for inlining
Change the frontend to only request the amount of results on the first page of the logs

How to test:

docker compose down --volumes && docker compose build --parallel && docker compose up --scale data-generation=1
Run the following query to create 30000 fake log entries:

DO
$$
BEGIN
    FOR i IN 1..30000 LOOP
        INSERT INTO backend_log(service_name, table_name) VALUES ('scraper', 'table');
    END LOOP;
END;
$$

Log in as admin and browse through te backend logs. It should be fast after the first page. When filtering, the count should be updated.

Closes #1092

PR Checklist:

sonarcloud[bot] commented 7 months ago

Kudos, no new issues were introduced!

sonarcloud[bot] commented 7 months ago

Kudos, no new issues were introduced!