delay at first program start after (re)boot of computer #1

ojrandom commented 2024年08月25日 19:29:50 +02:00

Loading of pictures causes a long delay

• when the program is started for the first time after a (re)boot of the computer
• not when the program is closed and started again

See comment of 9fc1be4aac

The sql that is is executed looks like this...

SELECT DISTINCT pictures.* FROM pictures JOIN faces ON pictures.id=faces.file_id WHERE faces.model='Facenet512' AND faces.detector= 'yolov8' AND has_errors!=1 AND faces.unknown!=1 AND faces.w>0 AND faces.ignore!= '1' AND date_shot >= DATE('2024年08月01日') AND date_shot <= DATE('2024年12月01日') ORDER BY time_shot DESC ;

SQLite executes the sql above very slowly after a (re)boot of the computer and very quickly it the program is closed and started again.

Does anybody know why?

Loading of pictures causes a long delay - when the program is started for the first time after a (re)boot of the computer - not when the program is closed and started again See comment of https://codeberg.org/ojrandom/ddc/commit/9fc1be4aac79f352e64a64d021acc810072a4444 The sql that is is executed looks like this... `SELECT DISTINCT pictures.* FROM pictures JOIN faces ON pictures.id=faces.file_id WHERE faces.model='Facenet512' AND faces.detector= 'yolov8' AND has_errors!=1 AND faces.unknown!=1 AND faces.w>0 AND faces.ignore!= '1' AND date_shot >= DATE('2024年08月01日') AND date_shot <= DATE('2024年12月01日') ORDER BY time_shot DESC ;` SQLite executes the sql above very slowly after a (re)boot of the computer and very quickly it the program is closed and started again. **Does anybody know why?**

ojrandom commented 2024年08月29日 15:52:07 +02:00

0ffb989765

Fixed with the above statement

https://codeberg.org/ojrandom/ddc/commit/0ffb989765407da424b1b158278a0ba13caa57d2 Fixed with the above statement