+- Forum darktable FR (https://forums.darktable.fr)
+-- Forum : Utilisation de darktable (https://forums.darktable.fr/forumdisplay.php?fid=97)
+--- Forum : Module Chambre Noire (https://forums.darktable.fr/forumdisplay.php?fid=75)
+--- Sujet : Lenteur d'accès au réglage photos (/showthread.php?tid=5561)
Pages :
1
2
RE: Lenteur d'accès au réglage photos - Gwen - 30-01-21
voici un extrait du log
avec option -d all
on dirai que darktable cherche ma camera sur le port usb
62,555939 [camera_control] loaded 6 port drivers.
à
100,104215 [camera_control] loaded 6 port drivers.
40 seconde d'attente
est ce bien ça ?
Code :
--extrait---
61,084380 [sql] /Users/parafin/src/darktable/src/common/image.c:313, function dt_image_full_path(): prepare "SELECT folder || '/' || filename FROM main.images i, main.film_rolls f WHERE i.film_id = f.id and i.id = ?1"
61,085940 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
61,086092 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
61,086224 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
61,086330 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
61,086432 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
61,086504 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
61,086588 [sql] /Users/parafin/src/darktable/src/common/tags.c:603, function dt_set_darktable_tags(): prepare "SELECT COUNT(*) FROM memory.darktable_tags"
61,086613 [sql] /Users/parafin/src/darktable/src/common/tags.c:656, function dt_tag_get_attached(): prepare "SELECT DISTINCT I.tagid, T.name, T.flags, T.synonyms, COUNT(DISTINCT I.imgid) AS inb FROM main.tagged_images AS I JOIN data.tags AS T ON T.id = I.tagid WHERE I.imgid IN (53115) AND T.id NOT IN memory.darktable_tags GROUP BY I.tagid ORDER by T.name"
61,086799 [sql] /Users/parafin/src/darktable/src/common/tags.c:603, function dt_set_darktable_tags(): prepare "SELECT COUNT(*) FROM memory.darktable_tags"
61,086823 [sql] /Users/parafin/src/darktable/src/common/tags.c:656, function dt_tag_get_attached(): prepare "SELECT DISTINCT I.tagid, T.name, T.flags, T.synonyms, COUNT(DISTINCT I.imgid) AS inb FROM main.tagged_images AS I JOIN data.tags AS T ON T.id = I.tagid WHERE I.imgid IN (53115) AND T.id NOT IN memory.darktable_tags GROUP BY I.tagid ORDER by T.name"
61,087005 [sql] /Users/parafin/src/darktable/src/common/tags.c:603, function dt_set_darktable_tags(): prepare "SELECT COUNT(*) FROM memory.darktable_tags"
61,087028 [sql] /Users/parafin/src/darktable/src/common/tags.c:1264, function dt_tag_get_with_usage(): prepare "INSERT INTO memory.taglist (id, count) SELECT tagid, COUNT(*) FROM main.tagged_images GROUP BY tagid"
61,094910 [sql] /Users/parafin/src/darktable/src/common/tags.c:1229, function dt_selected_images_count(): prepare "SELECT count(*) FROM main.selected_images"
61,094976 [sql] /Users/parafin/src/darktable/src/common/tags.c:1281, function dt_tag_get_with_usage(): prepare "SELECT T.name, T.id, MT.count, CT.imgnb, T.flags, T.synonyms FROM data.tags T LEFT JOIN memory.taglist MT ON MT.id = T.id LEFT JOIN (SELECT tagid, COUNT(DISTINCT imgid) AS imgnb FROM main.tagged_images WHERE imgid IN (SELECT imgid FROM main.selected_images) GROUP BY tagid) AS CT ON CT.tagid = T.id WHERE T.id NOT IN memory.darktable_tags ORDER BY T.name "
61,084380 [sql] /Users/parafin/src/darktable/src/common/image.c:313, function dt_image_full_path(): prepare "SELECT folder || '/' || filename FROM main.images i, main.film_rolls f WHERE i.film_id = f.id and i.id = ?1"
61,085940 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
61,086092 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
61,086224 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
61,086330 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
61,086432 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
61,086504 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
61,086588 [sql] /Users/parafin/src/darktable/src/common/tags.c:603, function dt_set_darktable_tags(): prepare "SELECT COUNT(*) FROM memory.darktable_tags"
61,086613 [sql] /Users/parafin/src/darktable/src/common/tags.c:656, function dt_tag_get_attached(): prepare "SELECT DISTINCT I.tagid, T.name, T.flags, T.synonyms, COUNT(DISTINCT I.imgid) AS inb FROM main.tagged_images AS I JOIN data.tags AS T ON T.id = I.tagid WHERE I.imgid IN (53115) AND T.id NOT IN memory.darktable_tags GROUP BY I.tagid ORDER by T.name"
61,086799 [sql] /Users/parafin/src/darktable/src/common/tags.c:603, function dt_set_darktable_tags(): prepare "SELECT COUNT(*) FROM memory.darktable_tags"
61,086823 [sql] /Users/parafin/src/darktable/src/common/tags.c:656, function dt_tag_get_attached(): prepare "SELECT DISTINCT I.tagid, T.name, T.flags, T.synonyms, COUNT(DISTINCT I.imgid) AS inb FROM main.tagged_images AS I JOIN data.tags AS T ON T.id = I.tagid WHERE I.imgid IN (53115) AND T.id NOT IN memory.darktable_tags GROUP BY I.tagid ORDER by T.name"
61,087005 [sql] /Users/parafin/src/darktable/src/common/tags.c:603, function dt_set_darktable_tags(): prepare "SELECT COUNT(*) FROM memory.darktable_tags"
61,087028 [sql] /Users/parafin/src/darktable/src/common/tags.c:1264, function dt_tag_get_with_usage(): prepare "INSERT INTO memory.taglist (id, count) SELECT tagid, COUNT(*) FROM main.tagged_images GROUP BY tagid"
61,094910 [sql] /Users/parafin/src/darktable/src/common/tags.c:1229, function dt_selected_images_count(): prepare "SELECT count(*) FROM main.selected_images"
61,094976 [sql] /Users/parafin/src/darktable/src/common/tags.c:1281, function dt_tag_get_with_usage(): prepare "SELECT T.name, T.id, MT.count, CT.imgnb, T.flags, T.synonyms FROM data.tags T LEFT JOIN memory.taglist MT ON MT.id = T.id LEFT JOIN (SELECT tagid, COUNT(DISTINCT imgid) AS imgnb FROM main.tagged_images WHERE imgid IN (SELECT imgid FROM main.selected_images) GROUP BY tagid) AS CT ON CT.tagid = T.id WHERE T.id NOT IN memory.darktable_tags ORDER BY T.name "
62,555939 [camera_control] loaded 6 port drivers.
62,588719 [camera_control] 0 cameras connected
65,444703 [sql] /Users/parafin/src/darktable/src/common/tags.c:1304, function dt_tag_get_with_usage(): exec "DELETE FROM memory.taglist"
66,722437 [camera_control] loaded 6 port drivers.
66,754403 [camera_control] 0 cameras connected
70,888176 [camera_control] loaded 6 port drivers.
70,920022 [camera_control] 0 cameras connected
75,065995 [camera_control] loaded 6 port drivers.
75,098091 [camera_control] 0 cameras connected
79,232863 [camera_control] loaded 6 port drivers.
79,263328 [camera_control] 0 cameras connected
83,414218 [camera_control] loaded 6 port drivers.
83,444291 [camera_control] 0 cameras connected
87,606963 [camera_control] loaded 6 port drivers.
87,640153 [camera_control] 0 cameras connected
91,777077 [camera_control] loaded 6 port drivers.
91,807026 [camera_control] 0 cameras connected
95,925173 [camera_control] loaded 6 port drivers.
95,955419 [camera_control] 0 cameras connected
100,104215 [camera_control] loaded 6 port drivers.
100,134584 [camera_control] 0 cameras connected
100,350298 [add_job_res] 0 | 100,350325 develop process image | queue: 0 | priority: 0100,350329
100,350358 [add_job_res] 1 | 100,350362 develop process preview | queue: 0 | priority: 0100,350365
100,350390 [run_job+] 00 321389543,242947 100,350406 develop process image | queue: 0 | priority: 0100,350414
100,350419 [run_job+] 01 321389543,242978 100,350455 develop process preview | queue: 0 | priority: 0100,350459
100,350468 100,350469 [dev] took 0,000 secs (0,000 CPU) to load the image.
[pixelpipe] pipeline state changed for pipe 4
100,350504 100,350508 [pixelpipe] pipeline state changed for pipe 2
[pixelpipe] synch all modules with defaults_params for pipe 4
100,350595 [params] commit for rawprepare in pipe 4 with hash 15340363110112797668
validation check failed in _iop_validate_params for type "float", field: g2
validation check failed in _iop_validate_params for type "dt_iop_temperature_params_t"
100,350625 [params] commit for temperature in pipe 4 with hash 14616125947125888376
100,350636 [params] commit for highlights in pipe 4 with hash 6428222210663212567
100,350649 [params] commit for demosaic in pipe 4 with hash 6359879594925717893
100,350663 [params] commit for flip in pipe 4 with hash 6381475781
100,350772 [params] commit for colorin in pipe 4 with hash 1455802194412340851
100,374629 [params] commit for colorout in pipe 4 with hash 10257528088492143908
100,374698 [params] commit for finalscale in pipe 4 with hash 6381440901
100,374715 [params] commit for overexposed in pipe 4 with hash 6381440901
100,374724 [params] commit for rawoverexposed in pipe 4 with hash 6381440901
100,374733 [params] commit for gamma in pipe 4 with hash 7567884774754821
100,374738 [pixelpipe] synch all modules with history for pipe 4
100,374754 [params] commit for rawprepare in pipe 4 with hash 15340363110112797668
100,374771 [params] commit for demosaic in pipe 4 with hash 6359879594925717893
100,374860 [params] commit for colorin in pipe 4 with hash 1455802194412340851
100,401841 [params] commit for colorout in pipe 4 with hash 10257528088492143908
100,401889 [params] commit for gamma in pipe 4 with hash 7567884774754821
100,401901 [params] commit for temperature in pipe 4 with hash 14616125947125888376
100,401912 [params] commit for highlights in pipe 4 with hash 6428222210663212567
100,401922 [params] commit for flip in pipe 4 with hash 6381475781
100,403944 [params] commit for basecurve in pipe 4 with hash 484382437236258012
100,404074 [params] commit for filmicrgb in pipe 4 with hash 1426964850665486284
100,404121 [pixelpipe_process] [preview] using device 0
[memory] before pixelpipe process
62,588719 [camera_control] 0 cameras connected
65,444703 [sql] /Users/parafin/src/darktable/src/common/tags.c:1304, function dt_tag_get_with_usage(): exec "DELETE FROM memory.taglist"
66,722437 [camera_control] loaded 6 port drivers.
66,754403 [camera_control] 0 cameras connected
70,888176 [camera_control] loaded 6 port drivers.
70,920022 [camera_control] 0 cameras connected
75,065995 [camera_control] loaded 6 port drivers.
75,098091 [camera_control] 0 cameras connected
79,232863 [camera_control] loaded 6 port drivers.
79,263328 [camera_control] 0 cameras connected
83,414218 [camera_control] loaded 6 port drivers.
83,444291 [camera_control] 0 cameras connected
87,606963 [camera_control] loaded 6 port drivers.
87,640153 [camera_control] 0 cameras connected
91,777077 [camera_control] loaded 6 port drivers.
91,807026 [camera_control] 0 cameras connected
95,925173 [camera_control] loaded 6 port drivers.
95,955419 [camera_control] 0 cameras connected
100,104215 [camera_control] loaded 6 port drivers.
100,134584 [camera_control] 0 cameras connected
100,350298 [add_job_res] 0 | 100,350325 develop process image | queue: 0 | priority: 0100,350329
100,350358 [add_job_res] 1 | 100,350362 develop process preview | queue: 0 | priority: 0100,350365
100,350390 [run_job+] 00 321389543,242947 100,350406 develop process image | queue: 0 | priority: 0100,350414
100,350419 [run_job+] 01 321389543,242978 100,350455 develop process preview | queue: 0 | priority: 0100,350459
100,350468 100,350469 [dev] took 0,000 secs (0,000 CPU) to load the image.
[pixelpipe] pipeline state changed for pipe 4
100,350504 100,350508 [pixelpipe] pipeline state changed for pipe 2
[pixelpipe] synch all modules with defaults_params for pipe 4
100,350595 [params] commit for rawprepare in pipe 4 with hash 15340363110112797668
validation check failed in _iop_validate_params for type "float", field: g2
validation check failed in _iop_validate_params for type "dt_iop_temperature_params_t"
100,350625 [params] commit for temperature in pipe 4 with hash 14616125947125888376
100,350636 [params] commit for highlights in pipe 4 with hash 6428222210663212567
100,350649 [params] commit for demosaic in pipe 4 with hash 6359879594925717893
100,350663 [params] commit for flip in pipe 4 with hash 6381475781
100,350772 [params] commit for colorin in pipe 4 with hash 1455802194412340851
100,374629 [params] commit for colorout in pipe 4 with hash 10257528088492143908
100,374698 [params] commit for finalscale in pipe 4 with hash 6381440901
100,374715 [params] commit for overexposed in pipe 4 with hash 6381440901
100,374724 [params] commit for rawoverexposed in pipe 4 with hash 6381440901
100,374733 [params] commit for gamma in pipe 4 with hash 7567884774754821
100,374738 [pixelpipe] synch all modules with history for pipe 4
100,374754 [params] commit for rawprepare in pipe 4 with hash 15340363110112797668
100,374771 [params] commit for demosaic in pipe 4 with hash 6359879594925717893
100,374860 [params] commit for colorin in pipe 4 with hash 1455802194412340851
100,401841 [params] commit for colorout in pipe 4 with hash 10257528088492143908
100,401889 [params] commit for gamma in pipe 4 with hash 7567884774754821
100,401901 [params] commit for temperature in pipe 4 with hash 14616125947125888376
100,401912 [params] commit for highlights in pipe 4 with hash 6428222210663212567
100,401922 [params] commit for flip in pipe 4 with hash 6381475781
100,403944 [params] commit for basecurve in pipe 4 with hash 484382437236258012
100,404074 [params] commit for filmicrgb in pipe 4 with hash 1426964850665486284
100,404121 [pixelpipe_process] [preview] using device 0
[memory] before pixelpipe process
en débranchant la camera j'ai encore le souci
657,911811 [camera_control] loaded 5 port drivers.
657,929364 [camera_control] 0 cameras connected
660,204092 [sql] /Users/parafin/src/darktable/src/common/tags.c:1304, function dt_tag_get_with_usage(): exec "DELETE FROM memory.taglist"
662,075993 [camera_control] loaded 5 port drivers.
662,094808 [camera_control] 0 cameras connected
666,216067 [camera_control] loaded 5 port drivers.
666,235945 [camera_control] 0 cameras connected
670,364151 [camera_control] loaded 5 port drivers.
670,383674 [camera_control] 0 cameras connected
674,537299 [camera_control] loaded 5 port drivers.
674,557128 [camera_control] 0 cameras connected
678,714180 [camera_control] loaded 5 port drivers.
678,733938 [camera_control] 0 cameras connected
682,897903 [camera_control] loaded 5 port drivers.
682,917794 [camera_control] 0 cameras connected
687,048108 [camera_control] loaded 5 port drivers.
687,069078 [camera_control] 0 cameras connectedRE: Lenteur d'accès au réglage photos - FrançoisH - 30-01-21
Pour la visibilité sur les smartphones, merci d'éditer ton post et de tout mettre le code dans la zone "code" qui va s'ouvrir en cliquant sur le parchemin "code" presque tout à gauche du format de texte.
RE: Lenteur d'accès au réglage photos - Gwen - 30-01-21
OK
le voici avec le format code
à regarder à partir de 61, 09 secondes
Code :
61,084380 [sql] /Users/parafin/src/darktable/src/common/image.c:313, function dt_image_full_path(): prepare "SELECT folder || '/' || filename FROM main.images i, main.film_rolls f WHERE i.film_id = f.id and i.id = ?1"
61,085940 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
61,086092 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
61,086224 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
61,086330 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
61,086432 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
61,086504 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
61,086588 [sql] /Users/parafin/src/darktable/src/common/tags.c:603, function dt_set_darktable_tags(): prepare "SELECT COUNT(*) FROM memory.darktable_tags"
61,086613 [sql] /Users/parafin/src/darktable/src/common/tags.c:656, function dt_tag_get_attached(): prepare "SELECT DISTINCT I.tagid, T.name, T.flags, T.synonyms, COUNT(DISTINCT I.imgid) AS inb FROM main.tagged_images AS I JOIN data.tags AS T ON T.id = I.tagid WHERE I.imgid IN (53115) AND T.id NOT IN memory.darktable_tags GROUP BY I.tagid ORDER by T.name"
61,086799 [sql] /Users/parafin/src/darktable/src/common/tags.c:603, function dt_set_darktable_tags(): prepare "SELECT COUNT(*) FROM memory.darktable_tags"
61,086823 [sql] /Users/parafin/src/darktable/src/common/tags.c:656, function dt_tag_get_attached(): prepare "SELECT DISTINCT I.tagid, T.name, T.flags, T.synonyms, COUNT(DISTINCT I.imgid) AS inb FROM main.tagged_images AS I JOIN data.tags AS T ON T.id = I.tagid WHERE I.imgid IN (53115) AND T.id NOT IN memory.darktable_tags GROUP BY I.tagid ORDER by T.name"
61,087005 [sql] /Users/parafin/src/darktable/src/common/tags.c:603, function dt_set_darktable_tags(): prepare "SELECT COUNT(*) FROM memory.darktable_tags"
61,087028 [sql] /Users/parafin/src/darktable/src/common/tags.c:1264, function dt_tag_get_with_usage(): prepare "INSERT INTO memory.taglist (id, count) SELECT tagid, COUNT(*) FROM main.tagged_images GROUP BY tagid"
61,094910 [sql] /Users/parafin/src/darktable/src/common/tags.c:1229, function dt_selected_images_count(): prepare "SELECT count(*) FROM main.selected_images"
61,094976 [sql] /Users/parafin/src/darktable/src/common/tags.c:1281, function dt_tag_get_with_usage(): prepare "SELECT T.name, T.id, MT.count, CT.imgnb, T.flags, T.synonyms FROM data.tags T LEFT JOIN memory.taglist MT ON MT.id = T.id LEFT JOIN (SELECT tagid, COUNT(DISTINCT imgid) AS imgnb FROM main.tagged_images WHERE imgid IN (SELECT imgid FROM main.selected_images) GROUP BY tagid) AS CT ON CT.tagid = T.id WHERE T.id NOT IN memory.darktable_tags ORDER BY T.name "
61,084380 [sql] /Users/parafin/src/darktable/src/common/image.c:313, function dt_image_full_path(): prepare "SELECT folder || '/' || filename FROM main.images i, main.film_rolls f WHERE i.film_id = f.id and i.id = ?1"
61,085940 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
61,086092 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
61,086224 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
61,086330 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
61,086432 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
61,086504 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
61,086588 [sql] /Users/parafin/src/darktable/src/common/tags.c:603, function dt_set_darktable_tags(): prepare "SELECT COUNT(*) FROM memory.darktable_tags"
61,086613 [sql] /Users/parafin/src/darktable/src/common/tags.c:656, function dt_tag_get_attached(): prepare "SELECT DISTINCT I.tagid, T.name, T.flags, T.synonyms, COUNT(DISTINCT I.imgid) AS inb FROM main.tagged_images AS I JOIN data.tags AS T ON T.id = I.tagid WHERE I.imgid IN (53115) AND T.id NOT IN memory.darktable_tags GROUP BY I.tagid ORDER by T.name"
61,086799 [sql] /Users/parafin/src/darktable/src/common/tags.c:603, function dt_set_darktable_tags(): prepare "SELECT COUNT(*) FROM memory.darktable_tags"
61,086823 [sql] /Users/parafin/src/darktable/src/common/tags.c:656, function dt_tag_get_attached(): prepare "SELECT DISTINCT I.tagid, T.name, T.flags, T.synonyms, COUNT(DISTINCT I.imgid) AS inb FROM main.tagged_images AS I JOIN data.tags AS T ON T.id = I.tagid WHERE I.imgid IN (53115) AND T.id NOT IN memory.darktable_tags GROUP BY I.tagid ORDER by T.name"
61,087005 [sql] /Users/parafin/src/darktable/src/common/tags.c:603, function dt_set_darktable_tags(): prepare "SELECT COUNT(*) FROM memory.darktable_tags"
61,087028 [sql] /Users/parafin/src/darktable/src/common/tags.c:1264, function dt_tag_get_with_usage(): prepare "INSERT INTO memory.taglist (id, count) SELECT tagid, COUNT(*) FROM main.tagged_images GROUP BY tagid"
61,094910 [sql] /Users/parafin/src/darktable/src/common/tags.c:1229, function dt_selected_images_count(): prepare "SELECT count(*) FROM main.selected_images"
61,094976 [sql] /Users/parafin/src/darktable/src/common/tags.c:1281, function dt_tag_get_with_usage(): prepare "SELECT T.name, T.id, MT.count, CT.imgnb, T.flags, T.synonyms FROM data.tags T LEFT JOIN memory.taglist MT ON MT.id = T.id LEFT JOIN (SELECT tagid, COUNT(DISTINCT imgid) AS imgnb FROM main.tagged_images WHERE imgid IN (SELECT imgid FROM main.selected_images) GROUP BY tagid) AS CT ON CT.tagid = T.id WHERE T.id NOT IN memory.darktable_tags ORDER BY T.name "
62,555939 [camera_control] loaded 6 port drivers.
62,588719 [camera_control] 0 cameras connected
65,444703 [sql] /Users/parafin/src/darktable/src/common/tags.c:1304, function dt_tag_get_with_usage(): exec "DELETE FROM memory.taglist"
66,722437 [camera_control] loaded 6 port drivers.
66,754403 [camera_control] 0 cameras connected
70,888176 [camera_control] loaded 6 port drivers.
70,920022 [camera_control] 0 cameras connected
75,065995 [camera_control] loaded 6 port drivers.
75,098091 [camera_control] 0 cameras connected
79,232863 [camera_control] loaded 6 port drivers.
79,263328 [camera_control] 0 cameras connected
83,414218 [camera_control] loaded 6 port drivers.
83,444291 [camera_control] 0 cameras connected
87,606963 [camera_control] loaded 6 port drivers.
87,640153 [camera_control] 0 cameras connected
91,777077 [camera_control] loaded 6 port drivers.
91,807026 [camera_control] 0 cameras connected
95,925173 [camera_control] loaded 6 port drivers.
95,955419 [camera_control] 0 cameras connected
100,104215 [camera_control] loaded 6 port drivers.
100,134584 [camera_control] 0 cameras connected
100,350298 [add_job_res] 0 | 100,350325 develop process image | queue: 0 | priority: 0100,350329
100,350358 [add_job_res] 1 | 100,350362 develop process preview | queue: 0 | priority: 0100,350365
100,350390 [run_job+] 00 321389543,242947 100,350406 develop process image | queue: 0 | priority: 0100,350414
100,350419 [run_job+] 01 321389543,242978 100,350455 develop process preview | queue: 0 | priority: 0100,350459
100,350468 100,350469 [dev] took 0,000 secs (0,000 CPU) to load the image.
[pixelpipe] pipeline state changed for pipe 4
100,350504 100,350508 [pixelpipe] pipeline state changed for pipe 2
[pixelpipe] synch all modules with defaults_params for pipe 4
100,350595 [params] commit for rawprepare in pipe 4 with hash 15340363110112797668
validation check failed in _iop_validate_params for type "float", field: g2
validation check failed in _iop_validate_params for type "dt_iop_temperature_params_t"
100,350625 [params] commit for temperature in pipe 4 with hash 14616125947125888376
100,350636 [params] commit for highlights in pipe 4 with hash 6428222210663212567
100,350649 [params] commit for demosaic in pipe 4 with hash 6359879594925717893
100,350663 [params] commit for flip in pipe 4 with hash 6381475781
100,350772 [params] commit for colorin in pipe 4 with hash 1455802194412340851
100,374629 [params] commit for colorout in pipe 4 with hash 10257528088492143908
100,374698 [params] commit for finalscale in pipe 4 with hash 6381440901
100,374715 [params] commit for overexposed in pipe 4 with hash 6381440901
100,374724 [params] commit for rawoverexposed in pipe 4 with hash 6381440901
100,374733 [params] commit for gamma in pipe 4 with hash 7567884774754821
100,374738 [pixelpipe] synch all modules with history for pipe 4
100,374754 [params] commit for rawprepare in pipe 4 with hash 15340363110112797668
100,374771 [params] commit for demosaic in pipe 4 with hash 6359879594925717893
100,374860 [params] commit for colorin in pipe 4 with hash 1455802194412340851
100,401841 [params] commit for colorout in pipe 4 with hash 10257528088492143908
100,401889 [params] commit for gamma in pipe 4 with hash 7567884774754821
100,401901 [params] commit for temperature in pipe 4 with hash 14616125947125888376
100,401912 [params] commit for highlights in pipe 4 with hash 6428222210663212567
100,401922 [params] commit for flip in pipe 4 with hash 6381475781
100,403944 [params] commit for basecurve in pipe 4 with hash 484382437236258012
100,404074 [params] commit for filmicrgb in pipe 4 with hash 1426964850665486284
100,404121 [pixelpipe_process] [preview] using device 0
[memory] before pixelpipe processRE: Lenteur d'accès au réglage photos - FrançoisH - 30-01-21
(30-01-21, 11:51)Gwen a écrit : OK
le voici avec le format code
à regarder à partir de 61, 09 secondes
Code :61,084380 [sql] /Users/parafin/src/darktable/src/common/image.c:313, function dt_image_full_path(): prepare "SELECT folder || '/' || filename FROM main.images i, main.film_rolls f WHERE i.film_id = f.id and i.id = ?1"
61,085940 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
61,086092 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
61,086224 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
61,086330 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
61,086432 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
61,086504 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
61,086588 [sql] /Users/parafin/src/darktable/src/common/tags.c:603, function dt_set_darktable_tags(): prepare "SELECT COUNT(*) FROM memory.darktable_tags"
61,086613 [sql] /Users/parafin/src/darktable/src/common/tags.c:656, function dt_tag_get_attached(): prepare "SELECT DISTINCT I.tagid, T.name, T.flags, T.synonyms, COUNT(DISTINCT I.imgid) AS inb FROM main.tagged_images AS I JOIN data.tags AS T ON T.id = I.tagid WHERE I.imgid IN (53115) AND T.id NOT IN memory.darktable_tags GROUP BY I.tagid ORDER by T.name"
61,086799 [sql] /Users/parafin/src/darktable/src/common/tags.c:603, function dt_set_darktable_tags(): prepare "SELECT COUNT(*) FROM memory.darktable_tags"
61,086823 [sql] /Users/parafin/src/darktable/src/common/tags.c:656, function dt_tag_get_attached(): prepare "SELECT DISTINCT I.tagid, T.name, T.flags, T.synonyms, COUNT(DISTINCT I.imgid) AS inb FROM main.tagged_images AS I JOIN data.tags AS T ON T.id = I.tagid WHERE I.imgid IN (53115) AND T.id NOT IN memory.darktable_tags GROUP BY I.tagid ORDER by T.name"
61,087005 [sql] /Users/parafin/src/darktable/src/common/tags.c:603, function dt_set_darktable_tags(): prepare "SELECT COUNT(*) FROM memory.darktable_tags"
61,087028 [sql] /Users/parafin/src/darktable/src/common/tags.c:1264, function dt_tag_get_with_usage(): prepare "INSERT INTO memory.taglist (id, count) SELECT tagid, COUNT(*) FROM main.tagged_images GROUP BY tagid"
61,094910 [sql] /Users/parafin/src/darktable/src/common/tags.c:1229, function dt_selected_images_count(): prepare "SELECT count(*) FROM main.selected_images"
61,094976 [sql] /Users/parafin/src/darktable/src/common/tags.c:1281, function dt_tag_get_with_usage(): prepare "SELECT T.name, T.id, MT.count, CT.imgnb, T.flags, T.synonyms FROM data.tags T LEFT JOIN memory.taglist MT ON MT.id = T.id LEFT JOIN (SELECT tagid, COUNT(DISTINCT imgid) AS imgnb FROM main.tagged_images WHERE imgid IN (SELECT imgid FROM main.selected_images) GROUP BY tagid) AS CT ON CT.tagid = T.id WHERE T.id NOT IN memory.darktable_tags ORDER BY T.name "
61,084380 [sql] /Users/parafin/src/darktable/src/common/image.c:313, function dt_image_full_path(): prepare "SELECT folder || '/' || filename FROM main.images i, main.film_rolls f WHERE i.film_id = f.id and i.id = ?1"
61,085940 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
61,086092 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
61,086224 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
61,086330 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
61,086432 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
61,086504 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
61,086588 [sql] /Users/parafin/src/darktable/src/common/tags.c:603, function dt_set_darktable_tags(): prepare "SELECT COUNT(*) FROM memory.darktable_tags"
61,086613 [sql] /Users/parafin/src/darktable/src/common/tags.c:656, function dt_tag_get_attached(): prepare "SELECT DISTINCT I.tagid, T.name, T.flags, T.synonyms, COUNT(DISTINCT I.imgid) AS inb FROM main.tagged_images AS I JOIN data.tags AS T ON T.id = I.tagid WHERE I.imgid IN (53115) AND T.id NOT IN memory.darktable_tags GROUP BY I.tagid ORDER by T.name"
61,086799 [sql] /Users/parafin/src/darktable/src/common/tags.c:603, function dt_set_darktable_tags(): prepare "SELECT COUNT(*) FROM memory.darktable_tags"
61,086823 [sql] /Users/parafin/src/darktable/src/common/tags.c:656, function dt_tag_get_attached(): prepare "SELECT DISTINCT I.tagid, T.name, T.flags, T.synonyms, COUNT(DISTINCT I.imgid) AS inb FROM main.tagged_images AS I JOIN data.tags AS T ON T.id = I.tagid WHERE I.imgid IN (53115) AND T.id NOT IN memory.darktable_tags GROUP BY I.tagid ORDER by T.name"
61,087005 [sql] /Users/parafin/src/darktable/src/common/tags.c:603, function dt_set_darktable_tags(): prepare "SELECT COUNT(*) FROM memory.darktable_tags"
61,087028 [sql] /Users/parafin/src/darktable/src/common/tags.c:1264, function dt_tag_get_with_usage(): prepare "INSERT INTO memory.taglist (id, count) SELECT tagid, COUNT(*) FROM main.tagged_images GROUP BY tagid"
61,094910 [sql] /Users/parafin/src/darktable/src/common/tags.c:1229, function dt_selected_images_count(): prepare "SELECT count(*) FROM main.selected_images"
61,094976 [sql] /Users/parafin/src/darktable/src/common/tags.c:1281, function dt_tag_get_with_usage(): prepare "SELECT T.name, T.id, MT.count, CT.imgnb, T.flags, T.synonyms FROM data.tags T LEFT JOIN memory.taglist MT ON MT.id = T.id LEFT JOIN (SELECT tagid, COUNT(DISTINCT imgid) AS imgnb FROM main.tagged_images WHERE imgid IN (SELECT imgid FROM main.selected_images) GROUP BY tagid) AS CT ON CT.tagid = T.id WHERE T.id NOT IN memory.darktable_tags ORDER BY T.name "
62,555939 [camera_control] loaded 6 port drivers.
62,588719 [camera_control] 0 cameras connected
65,444703 [sql] /Users/parafin/src/darktable/src/common/tags.c:1304, function dt_tag_get_with_usage(): exec "DELETE FROM memory.taglist"
66,722437 [camera_control] loaded 6 port drivers.
66,754403 [camera_control] 0 cameras connected
70,888176 [camera_control] loaded 6 port drivers.
70,920022 [camera_control] 0 cameras connected
75,065995 [camera_control] loaded 6 port drivers.
75,098091 [camera_control] 0 cameras connected
79,232863 [camera_control] loaded 6 port drivers.
79,263328 [camera_control] 0 cameras connected
83,414218 [camera_control] loaded 6 port drivers.
83,444291 [camera_control] 0 cameras connected
87,606963 [camera_control] loaded 6 port drivers.
87,640153 [camera_control] 0 cameras connected
91,777077 [camera_control] loaded 6 port drivers.
91,807026 [camera_control] 0 cameras connected
95,925173 [camera_control] loaded 6 port drivers.
95,955419 [camera_control] 0 cameras connected
100,104215 [camera_control] loaded 6 port drivers.
100,134584 [camera_control] 0 cameras connected
100,350298 [add_job_res] 0 | 100,350325 develop process image | queue: 0 | priority: 0100,350329
100,350358 [add_job_res] 1 | 100,350362 develop process preview | queue: 0 | priority: 0100,350365
100,350390 [run_job+] 00 321389543,242947 100,350406 develop process image | queue: 0 | priority: 0100,350414
100,350419 [run_job+] 01 321389543,242978 100,350455 develop process preview | queue: 0 | priority: 0100,350459
100,350468 100,350469 [dev] took 0,000 secs (0,000 CPU) to load the image.
[pixelpipe] pipeline state changed for pipe 4
100,350504 100,350508 [pixelpipe] pipeline state changed for pipe 2
[pixelpipe] synch all modules with defaults_params for pipe 4
100,350595 [params] commit for rawprepare in pipe 4 with hash 15340363110112797668
validation check failed in _iop_validate_params for type "float", field: g2
validation check failed in _iop_validate_params for type "dt_iop_temperature_params_t"
100,350625 [params] commit for temperature in pipe 4 with hash 14616125947125888376
100,350636 [params] commit for highlights in pipe 4 with hash 6428222210663212567
100,350649 [params] commit for demosaic in pipe 4 with hash 6359879594925717893
100,350663 [params] commit for flip in pipe 4 with hash 6381475781
100,350772 [params] commit for colorin in pipe 4 with hash 1455802194412340851
100,374629 [params] commit for colorout in pipe 4 with hash 10257528088492143908
100,374698 [params] commit for finalscale in pipe 4 with hash 6381440901
100,374715 [params] commit for overexposed in pipe 4 with hash 6381440901
100,374724 [params] commit for rawoverexposed in pipe 4 with hash 6381440901
100,374733 [params] commit for gamma in pipe 4 with hash 7567884774754821
100,374738 [pixelpipe] synch all modules with history for pipe 4
100,374754 [params] commit for rawprepare in pipe 4 with hash 15340363110112797668
100,374771 [params] commit for demosaic in pipe 4 with hash 6359879594925717893
100,374860 [params] commit for colorin in pipe 4 with hash 1455802194412340851
100,401841 [params] commit for colorout in pipe 4 with hash 10257528088492143908
100,401889 [params] commit for gamma in pipe 4 with hash 7567884774754821
100,401901 [params] commit for temperature in pipe 4 with hash 14616125947125888376
100,401912 [params] commit for highlights in pipe 4 with hash 6428222210663212567
100,401922 [params] commit for flip in pipe 4 with hash 6381475781
100,403944 [params] commit for basecurve in pipe 4 with hash 484382437236258012
100,404074 [params] commit for filmicrgb in pipe 4 with hash 1426964850665486284
100,404121 [pixelpipe_process] [preview] using device 0
[memory] before pixelpipe process
Merci
RE: Lenteur d'accès au réglage photos - nicoauffray - 30-01-21
(30-01-21, 11:51)Gwen a écrit : OK
le voici avec le format code
Ca aurait été encore mieux d'éditer le précédent post pour réduire la longueur du fil et faciliter la visibilité.
RE: Lenteur d'accès au réglage photos - G.Eco - 31-01-21
(30-01-21, 10:14)Gwen a écrit : voici un extrait du logPour en revenir au fond du problème, je viens de tester simplement en chargeant une image dans la chambre noire, sans rien faire d'autre, et il apparaît à intervalles plus ou moins réguliers (à peu près toutes les 4s, comme pour toi) des lignes semblables aux tiennes :
avec option -d all
on dirai que darktable cherche ma camera sur le port usb
62,555939 [camera_control] loaded 6 port drivers.
à
100,104215 [camera_control] loaded 6 port drivers.
40 seconde d'attente
est ce bien ça ?
141,420491 [camera_control] loaded 36 port drivers.
141,428945 [camera_control] 0 cameras connected
donc je pense que c'est un fonctionnement normal de dt (il faudrait qu'un développeur puisse nous éclairer sur ce point) et je ne pense pas que ce soit la cause de ton problème.
Il faudrait plutôt isoler dans ton log ce qui ne concerne pas cette histoire de [camera_control] et voir ce qui bloque pendant une trentaine de secondes, ce qui donne ceci :
Code :
61,087005 [sql] /Users/parafin/src/darktable/src/common/tags.c:603, function dt_set_darktable_tags(): prepare "SELECT COUNT(*) FROM memory.darktable_tags"
61,087028 [sql] /Users/parafin/src/darktable/src/common/tags.c:1264, function dt_tag_get_with_usage(): prepare "INSERT INTO memory.taglist (id, count) SELECT tagid, COUNT(*) FROM main.tagged_images GROUP BY tagid"
61,094910 [sql] /Users/parafin/src/darktable/src/common/tags.c:1229, function dt_selected_images_count(): prepare "SELECT count(*) FROM main.selected_images"
61,094976 [sql] /Users/parafin/src/darktable/src/common/tags.c:1281, function dt_tag_get_with_usage(): prepare "SELECT T.name, T.id, MT.count, CT.imgnb, T.flags, T.synonyms FROM data.tags T LEFT JOIN memory.taglist MT ON MT.id = T.id LEFT JOIN (SELECT tagid, COUNT(DISTINCT imgid) AS imgnb FROM main.tagged_images WHERE imgid IN (SELECT imgid FROM main.selected_images) GROUP BY tagid) AS CT ON CT.tagid = T.id WHERE T.id NOT IN memory.darktable_tags ORDER BY T.name "
65,444703 [sql] /Users/parafin/src/darktable/src/common/tags.c:1304, function dt_tag_get_with_usage(): exec "DELETE FROM memory.taglist"
100,350298 [add_job_res] 0 | 100,350325 develop process image | queue: 0 | priority: 0100,350329
100,350358 [add_job_res] 1 | 100,350362 develop process preview | queue: 0 | priority: 0100,350365
100,350390 [run_job+] 00 321389543,242947 100,350406 develop process image | queue: 0 | priority: 0100,350414
100,350419 [run_job+] 01 321389543,242978 100,350455 develop process preview | queue: 0 | priority: 0100,350459
100,350468 100,350469 [dev] took 0,000 secs (0,000 CPU) to load the image.
[pixelpipe] pipeline state changed for pipe 4
100,350504 100,350508 [pixelpipe] pipeline state changed for pipe 2
[pixelpipe] synch all modules with defaults_params for pipe 4Est-ce cette requête SQL qui pose problème et pour quelle raison ?
65,444703 [sql] /Users/parafin/src/darktable/src/common/tags.c:1304, function dt_tag_get_with_usage(): exec "DELETE FROM memory.taglist"
RE: Lenteur d'accès au réglage photos - Gwen - 31-01-21
Bonjour j'ai effectivement constaté la meme chose coté usb driver - "62,555939 [camera_control] loaded 6 port drivers"
Et ce que tu signale en remontant sur la ligne précédente c'est ce que je soupçonne depuis le début une requête SQL (accès à la base de donnée)
"Est-ce cette requête SQL qui pose problème et pour quelle raison ?"
65,444703 [sql] /Users/parafin/src/darktable/src/common/tags.c:1304, function dt_tag_get_with_usage(): exec "DELETE FROM memory.taglist"
Est ce ma base donnée qui a des soucis ou est ce propre à ma configuration? Comment peut on identifier le problème ?
A+