very slow darktable startup

Hi! I have a terrible slowdown at darktable startup:

$ darktable -d all
[memory] at startup
[memory] max address space (vmpeak):      333960 kB
[memory] cur address space (vmsize):      333960 kB
[memory] max used memory   (vmhwm ):       20468 kB
[memory] cur used memory   (vmrss ):       20468 kB
0,048733 [sql] /build/darktable-TKGQbh/darktable-2.6.2/src/common/collection.c:605, function _dt_collection_compute_count(): prepare "SELECT COUNT(DISTINCT a.id) FROM images AS a WHERE   (flags & 256) != 256 AND (1=1 AND (film_id IN (SELECT id FROM main.film_rolls WHERE folder LIKE '/home/paolo/raw da macchina/Post Cresima Voltri 2019-06'))) ORDER BY datetime_taken, filename, version LIMIT ?1, ?2"
0,049163 [sql] /build/darktable-TKGQbh/darktable-2.6.2/src/common/collection.c:605, function _dt_collection_compute_count(): prepare "SELECT COUNT(DISTINCT a.id) FROM images AS a WHERE   (flags & 256) != 256 AND (1=1 AND (film_id IN (SELECT id FROM main.film_rolls WHERE folder LIKE '/home/paolo/raw da macchina/Post Cresima Voltri 2019-06'))) ORDER BY datetime_taken, filename, version LIMIT ?1, ?2"
0,049299 [sql] /build/darktable-TKGQbh/darktable-2.6.2/src/common/collection.c:676, function dt_collection_get(): prepare "SELECT DISTINCT a.id FROM main.images AS a WHERE a.id IN (SELECT imgid FROM main.selected_images) ORDER BY datetime_taken, filename, version LIMIT ?1"
0,049366 [sql] /build/darktable-TKGQbh/darktable-2.6.2/src/common/collection.c:1531, function dt_collection_image_offset_with_collection(): prepare "SELECT DISTINCT id FROM images AS a WHERE   (flags & 256) != 256 AND (1=1 AND (film_id IN (SELECT id FROM main.film_rolls WHERE folder LIKE '/home/paolo/raw da macchina/Post Cresima Voltri 2019-06'))) ORDER BY datetime_taken, filename, version LIMIT ?1, ?2"
0,049484 [sql] /build/darktable-TKGQbh/darktable-2.6.2/src/common/collection.c:634, function dt_collection_get_selected_count(): prepare "SELECT COUNT(*) FROM main.selected_images"
0,049524 [sql] /build/darktable-TKGQbh/darktable-2.6.2/src/common/collection.c:1466, function dt_collection_update_query(): prepare "DELETE FROM main.selected_images WHERE imgid NOT IN (SELECT DISTINCT id FROM images AS a WHERE   (flags & 256) != 256 AND (1=1 AND (film_id IN (SELECT id FROM main.film_rolls WHERE folder LIKE '/home/paolo/raw da macchina/Post Cresima Voltri 2019-06'))) ORDER BY datetime_taken, filename, version LIMIT ?1, ?2)"
0,049740 [sql] /build/darktable-TKGQbh/darktable-2.6.2/src/common/collection.c:605, function _dt_collection_compute_count(): prepare "SELECT COUNT(DISTINCT a.id) FROM images AS a WHERE   (flags & 256) != 256 AND (1=1 AND (film_id IN (SELECT id FROM main.film_rolls WHERE folder LIKE '/home/paolo/raw da macchina/Post Cresima Voltri 2019-06'))) ORDER BY datetime_taken, filename, version"
0,049845 [sql] /build/darktable-TKGQbh/darktable-2.6.2/src/common/collection.c:605, function _dt_collection_compute_count(): prepare "SELECT COUNT(DISTINCT a.id) FROM images AS a WHERE   (flags & 256) != 256 AND (1=1 AND (film_id IN (SELECT id FROM main.film_rolls WHERE folder LIKE '/home/paolo/raw da macchina/Post Cresima Voltri 2019-06'))) ORDER BY datetime_taken, filename, version"
0,049944 [sql] /build/darktable-TKGQbh/darktable-2.6.2/src/common/collection.c:676, function dt_collection_get(): prepare "SELECT DISTINCT a.id FROM main.images AS a WHERE a.id IN (SELECT imgid FROM main.selected_images) ORDER BY datetime_taken, filename, version LIMIT ?1"
0,049987 [sql] /build/darktable-TKGQbh/darktable-2.6.2/src/common/collection.c:1531, function dt_collection_image_offset_with_collection(): prepare "SELECT DISTINCT id FROM images AS a WHERE   (flags & 256) != 256 AND (1=1 AND (film_id IN (SELECT id FROM main.film_rolls WHERE folder LIKE '/home/paolo/raw da macchina/Post Cresima Voltri 2019-06'))) ORDER BY datetime_taken, filename, version"
0,050067 [sql] /build/darktable-TKGQbh/darktable-2.6.2/src/common/collection.c:634, function dt_collection_get_selected_count(): prepare "SELECT COUNT(*) FROM main.selected_images"
0,050097 [pwstorage_new] Creating new context 0x5604ca6773f0
0,050104 [pwstorage_new] using libsecret backend for username/password storage15.176176 [opencl_init] opencl related configuration options:
15.176194 [opencl_init] 
15.176199 [opencl_init] opencl: 1
15.176206 [opencl_init] opencl_library: ''
15.176218 [opencl_init] opencl_memory_requirement: 768
15.176226 [opencl_init] opencl_memory_headroom: 300
15.176233 [opencl_init] opencl_device_priority: '*/!0,*/*/*'
15.176243 [opencl_init] opencl_mandatory_timeout: 200
15.176251 [opencl_init] opencl_size_roundup: 16
15.176258 [opencl_init] opencl_async_pixelpipe: 0
15.176265 [opencl_init] opencl_synch_cache: 0
15.176273 [opencl_init] opencl_number_event_handles: 25
15.176281 [opencl_init] opencl_micro_nap: 1000
15.176288 [opencl_init] opencl_use_pinned_memory: 0
15.176295 [opencl_init] opencl_use_cpu_devices: 0
15.176301 [opencl_init] opencl_avoid_atomics: 0
15.176307 [opencl_init] 

would it be an issue with libsecret? any hint?

Iā€™m on linux ubuntu bionic.

$ darktable --version
this is darktable 2.6.2
copyright (c) 2009-2019 johannes hanika
darktable-dev@lists.darktable.org

compile options:
  bit depth is 64 bit
  normal build
  SSE2 optimized codepath enabled
  OpenMP support enabled
  OpenCL support enabled
  Lua support enabled, API version 5.0.1
  Colord support enabled
  gPhoto2 support enabled
  GraphicsMagick support enabled
  OpenEXR support enabled

Not sure what the problem is, but my password back end (in the preferences) is set to none. Maybe you can try that.

1 Like

ok, that made the trick, thank you!

2 Likes