https://bugs.kde.org/show_bug.cgi?id=431951
--- Comment #46 from griffiths_a...@icloud.com --- andyg@arch ~/Pictures/digikam % sqlite3 digikam4.db SQLite version 3.34.1 2021-01-20 14:10:07 Enter ".help" for usage hints. sqlite> .timer on sqlite> .mode csv sqlite> .output datequery.csv sqlite> SELECT creationDate FROM ImageInformation INNER JOIN Images ON Images.id=ImageInformation.imageid WHERE Images.status=1; Run Time: real 0.174 user 0.136208 sys 0.037326 sqlite> .output stdout sqlite> .q andyg@arch ~/Pictures/digikam % wc -l datequery.csv 405890 datequery.csv Query took hardly any time at all for 405890 results. Agreed, it shouldn't take 12 seconds in digikam. -- You are receiving this mail because: You are watching all bug changes.