Project

General

Profile

Bug #11572

Extreme high CPU usage when hovering over thumbnails in lighttable and darkroom mode

Added by Joe Heb 15 days ago. Updated 8 days ago.

Status:
New
Priority:
Low
Assignee:
-
Category:
General
Target version:
-
Start date:
04/13/2017
Due date:
% Done:

0%

Affected Version:
2.2.3
System:
Fedora/RHEL
bitness:
64-bit
hardware architecture:
amd64/x86

Description

When I hover over either the thumbnails in lighttable or the thumbnails at the bottom of darkroom the CPU goes up very high. When starting darktable with the -d output, I see the following lines when moving the mouse:

_
[sql] /builddir/build/BUILD/darktable-2.2.3/src/common/metadata.c:179, function dt_metadata_get_xmp(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
[sql] /builddir/build/BUILD/darktable-2.2.3/src/common/metadata.c:179, function dt_metadata_get_xmp(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
[sql] /builddir/build/BUILD/darktable-2.2.3/src/common/metadata.c:179, function dt_metadata_get_xmp(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
[sql] /builddir/build/BUILD/darktable-2.2.3/src/common/tags.c:335, function dt_tag_get_attached(): prepare "SELECT DISTINCT T.id, T.name FROM main.tagged_images AS I, data.tags AS T WHERE I.imgid IN (SELECT imgid FROM main.selected_images) AND T.id = I.tagid ORDER BY T.name"
[lighttable] image expose took 0,0010 sec
[lighttable] image expose took 0,0009 sec
[lighttable] image expose took 0,0008 sec
[lighttable] image expose took 0,0007 sec
[lighttable] image expose took 0,0003 sec
[lighttable] image expose took 0,0003 sec
[lighttable] image expose took 0,0003 sec
[lighttable] image expose took 0,0003 sec
[lighttable] image expose took 0,0008 sec
[lighttable] image expose took 0,0008 sec
[lighttable] image expose took 0,0008 sec
[lighttable] image expose took 0,0007 sec
[lighttable] image expose took 0,0041 sec
[lighttable] image expose took 0,0003 sec
[lighttable] image expose took 0,0003 sec
[lighttable] image expose took 0,0002 sec
[lighttable] image expose took 0,0007 sec
[lighttable] image expose took 0,0007 sec
[lighttable] image expose took 0,0007 sec
[lighttable] image expose took 0,0007 sec
[lighttable] image expose took 0,0007 sec
[lighttable] image expose took 0,0007 sec
[lighttable] image expose took 0,0007 sec
[lighttable] image expose took 0,0007 sec
[lighttable] image expose took 0,0007 sec
[lighttable] image expose took 0,0007 sec
[lighttable] image expose took 0,0007 sec
[lighttable] image expose took 0,0007 sec
[lighttable] image expose took 0,0007 sec
[lighttable] image expose took 0,0007 sec
[lighttable] image expose took 0,0002 sec
[lighttable] image expose took 0,0002 sec
[lighttable] image expose took 0,0002 sec
[lighttable] image expose took 0,0002 sec
[lighttable] image expose took 0,0002 sec
[mipmap_cache] thumbs fill 12,84/512,00 MB (2,51%)
[mipmap_cache] float fill 1/4 slots (25,00%)
[mipmap_cache] full fill 2/4 slots (50,00%)
[mipmap_cache] level | near match | miss | stand-in | fetches | total rq
[mipmap_cache] thumb | 0,41% | 0,22% | 100,00% | 25,00% | 99,94%
[mipmap_cache] float | 75,00% | 75,00% | 0,00% | 25,00% | 0,06%
[mipmap_cache] full | -nan% | -nan% | 0,00% | 50,00% | 0,00%

[lighttable] expose took 0,0238 sec_

When hovering in darkroom mode, it looks like:

image expose took 0,0009 sec
[lighttable] image expose took 0,0021 sec
[lighttable] image expose took 0,0021 sec
[sql] /builddir/build/BUILD/darktable-2.2.3/src/common/image.c:136, function dt_image_film_roll(): prepare "SELECT folder FROM main.film_rolls WHERE id = ?1"
[sql] /builddir/build/BUILD/darktable-2.2.3/src/common/image.c:181, 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"
[sql] /builddir/build/BUILD/darktable-2.2.3/src/common/metadata.c:179, function dt_metadata_get_xmp(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
[sql] /builddir/build/BUILD/darktable-2.2.3/src/common/metadata.c:179, function dt_metadata_get_xmp(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
[sql] /builddir/build/BUILD/darktable-2.2.3/src/common/metadata.c:179, function dt_metadata_get_xmp(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
[sql] /builddir/build/BUILD/darktable-2.2.3/src/common/tags.c:317, function dt_tag_get_attached(): prepare "SELECT DISTINCT T.id, T.name FROM main.tagged_images AS I JOIN data.tags T on T.id = I.tagid WHERE I.imgid = 29388 ORDER BY T.name"
[sql] /builddir/build/BUILD/darktable-2.2.3/src/common/image.c:629, function dt_image_altered(): prepare "SELECT operation FROM main.history WHERE imgid = ?1"
[lighttable] image expose took 0,0028 sec
[lighttable] image expose took 0,0025 sec
[lighttable] image expose took 0,0021 sec
[lighttable] image expose took 0,0021 sec
[lighttable] image expose took 0,0015 sec
[lighttable] image expose took 0,0007 sec
[sql] /builddir/build/BUILD/darktable-2.2.3/src/common/image.c:136, function dt_image_film_roll(): prepare "SELECT folder FROM main.film_rolls WHERE id = ?1"
[sql] /builddir/build/BUILD/darktable-2.2.3/src/common/image.c:181, 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"
[sql] /builddir/build/BUILD/darktable-2.2.3/src/common/metadata.c:179, function dt_metadata_get_xmp(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
[sql] /builddir/build/BUILD/darktable-2.2.3/src/common/metadata.c:179, function dt_metadata_get_xmp(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
[sql] /builddir/build/BUILD/darktable-2.2.3/src/common/metadata.c:179, function dt_metadata_get_xmp(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value"
[sql] /builddir/build/BUILD/darktable-2.2.3/src/common/tags.c:317, function dt_tag_get_attached(): prepare "SELECT DISTINCT T.id, T.name FROM main.tagged_images AS I JOIN data.tags T on T.id = I.tagid WHERE I.imgid = 29389 ORDER BY T.name"
[sql] /builddir/build/BUILD/darktable-2.2.3/src/libs/tools/filmstrip.c:706, function _lib_filmstrip_draw_callback(): prepare "SELECT DISTINCT id FROM main.images WHERE (flags & 256) != 256 AND ((film_id IN (SELECT id FROM main.film_rolls WHERE folder LIKE '/home/jrn/Bilder/RAW/2016/201608 August/20160811 Urlaub Frankreich%'))) ORDER BY filename, version LIMIT ?1, ?2"
[lighttable] image expose took 0,0009 sec
[lighttable] image expose took 0,0020 sec
[lighttable] image expose took 0,0021 sec
[lighttable] image expose took 0,0025 sec
[sql] /builddir/build/BUILD/darktable-2.2.3/src/common/image.c:629, function dt_image_altered(): prepare "SELECT operation FROM main.history WHERE imgid = ?1"
[lighttable] image expose took 0,0028 sec
[lighttable] image expose took 0,0022 sec
[lighttable] image expose took 0,0024 sec
[lighttable] image expose took 0,0018 sec
[lighttable] image expose took 0,0007 sec

History

#1 Updated by Peter Grodovsky 8 days ago

Hi, this seems to be the same problem as issue #10764

Also available in: Atom PDF