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.

Reply via email to