adam/Piwigo
1
0 Fork 0
mirror of https://github.com/Piwigo/Piwigo.git synced 2026-11-03 07:22:22 +01:00
Code Issues 657 Packages Projects Releases Wiki Activity

[albums] performance issue on edition page, when too many photos #853

New Issue
Closed
opened 2026-10-05 00:20:56 +02:00 by adam · 0 comments
adam commented 2026-10-05 00:20:56 +02:00
Owner
Copy link
Copy source

If you have too many photos (in our specific case, that's 52k photos in sub-albums), the "new" algorithm to detect how many photos would become orphans if we delete the album. Indeed Piwigo sends the full list of image_ids associated to the album (and sub-albums).

In my current case, the SQL query takes 78 seconds and simply leads to Gateway Timeoutin nginx.

If you have too many photos (in our specific case, that's 52k photos in sub-albums), the "new" algorithm to detect how many photos would become orphans if we delete the album. Indeed Piwigo sends the full list of image_ids associated to the album (and sub-albums). In my current case, the SQL query takes 78 seconds and simply leads to `Gateway Timeout`in nginx. <!-- github-sync-id:403756743 -->
adam closed this issue 2026-10-05 00:20:56 +02:00
adam changed title from [albums] performance issue on edition page, when too many photos to [albums] performance issue on edition page, when too many photos 2026-10-27 11:12:52 +01:00
Sign in to join this conversation.
No Branch/Tag Specified
Labels
No items
No labels
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
adam (Adam Wojcieszonek)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: adam/Piwigo#853