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

album edition, timeout #1202

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

Following #972 and b29ab344e9 it seems the 30k threshold is a bit high. For example, on a low energy CPU server on Piwigo.com, an album containing 19k photos made the SQL query run for a huge 98 seconds.

Let's lower the limit to 1k. The pure PHP solution remains fine.

Actually, this calculation (of the number of photos that would become orphan if the album was deleted) should be done only if the administrator asks for deletion. Totally useless 99% of the time.

Following #972 and b29ab344e9d727f483613f244d11e8971cb03df1 it seems the 30k threshold is a bit high. For example, on a low energy CPU server on Piwigo.com, an album containing 19k photos made the SQL query run for a huge 98 seconds. Let's lower the limit to 1k. The pure PHP solution remains fine. Actually, this calculation (of the number of photos that would become orphan if the album was deleted) should be done **only** if the administrator asks for deletion. Totally useless 99% of the time. <!-- github-sync-id:856687183 -->
adam closed this issue 2026-10-05 00:35:53 +02: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#1202