adam/Piwigo
1
0 Fork 0
mirror of https://github.com/Piwigo/Piwigo.git synced 2026-10-31 06:02:00 +01:00
Code Issues 657 Packages Projects Releases Wiki Activity

calculating number of orphans is slow #1575

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

With more hundreds of thousands photos, calculating the number of orphan photos, performed on each admin page, is slow:

SELECT
    id
  FROM images
    LEFT JOIN image_category ON id = image_id
  WHERE category_id is null
  ORDER BY id ASC
;
(this query time : 1.862 s)

We may not need to calculate this on each page, every second...

With more hundreds of thousands photos, calculating the number of orphan photos, performed on each admin page, is slow: ``` SELECT id FROM images LEFT JOIN image_category ON id = image_id WHERE category_id is null ORDER BY id ASC ; (this query time : 1.862 s) ``` We may not need to calculate this on each page, every second... <!-- github-sync-id:1459556238 -->
adam closed this issue 2026-10-05 00:48:47 +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#1575