starred/koel-koel

Fork 0

mirror of https://github.com/koel/koel.git synced 2026-04-26 09:15:59 +03:00

[GH-ISSUE #1508] Improving Postgres Database Performances #867

New issue

Closed

opened 2026-02-26 02:34:28 +03:00 by kerem · 2 comments

kerem commented

2026-02-26 02:34:28 +03:00

Owner

Originally created by @dhenry123 on GitHub (Sep 19, 2022).
Original GitHub issue: https://github.com/koel/koel/issues/1508

i built one posgresql database with more than 14000/1000 (songs/albums) and i got latency on scrolling albums

I added this index :

CREATE INDEX songs_album_id_index ON public.songs USING btree (album_id);

API : /api/albums?page=7

Time loading between each page (arm64 platform/raspberry-pi4/kubernetes) :

No index	with new index
4 seconds	700 milliseconds

+++

Originally created by @dhenry123 on GitHub (Sep 19, 2022). Original GitHub issue: https://github.com/koel/koel/issues/1508 i built one posgresql database with more than 14000/1000 (songs/albums) and i got latency on scrolling albums I added this index : ``` CREATE INDEX songs_album_id_index ON public.songs USING btree (album_id); ``` API : /api/albums?page=7 Time loading between each page (arm64 platform/raspberry-pi4/kubernetes) : | No index | with new index | | ------- | -------- | | 4 seconds | 700 milliseconds | +++

kerem closed this issue

2026-02-26 02:34:28 +03:00

kerem commented

2026-02-26 02:34:29 +03:00

Author

Owner

@phanan commented on GitHub (Sep 21, 2022):

Do you think you can send a PR?

@phanan commented on GitHub (Sep 21, 2022): Do you think you can send a PR?

kerem commented

2026-02-26 02:34:29 +03:00

Author

Owner

@phanan commented on GitHub (Oct 26, 2022):

Closed by #1547.

@phanan commented on GitHub (Oct 26, 2022): Closed by #1547.

kerem referenced this issue

2026-02-26 03:30:53 +03:00

[PR #867] [MERGED] Bump doctrine/dbal from 2.8.0 to 2.9.0 #1403

No milestone

No project

No assignees

1 participant

Notifications

Due date

The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference

starred/koel-koel#867

No description provided.

Rows
Columns