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

calculating number of orphans is (still) slow #1600

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

Following #1801 I can still see this kind of query on admin dashboard

SELECT
    id
  FROM images
    LEFT JOIN image_category ON id = image_id
  WHERE category_id is null
  ORDER BY id ASC
;
(this query time : 7.399 s)
(total SQL time  : 7.450 s)
(total time      : 7.524 s)
(num rows        : 10 )

7.399 seconds is huge. This gallery may have 500k photos, there must be a way to find the number of orphans faster.

Following #1801 I can still see this kind of query on admin dashboard ``` SELECT id FROM images LEFT JOIN image_category ON id = image_id WHERE category_id is null ORDER BY id ASC ; (this query time : 7.399 s) (total SQL time : 7.450 s) (total time : 7.524 s) (num rows : 10 ) ``` 7.399 seconds is huge. This gallery may have 500k photos, there must be a way to find the number of orphans faster. <!-- github-sync-id:1499923037 -->
adam closed this issue 2026-10-05 00:49:56 +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#1600