[Digikam-devel] [digikam] [Bug 341111] New: Deleting an image involves "too many" queries

Roy Bellingan admin at seisho.us
Thu Nov 20 02:07:18 GMT 2014


            Bug ID: 341111
           Summary: Deleting an image involves "too many" queries
           Product: digikam
           Version: 4.4.0
          Platform: openSUSE RPMs
                OS: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: Database
          Assignee: digikam-devel at kde.org
          Reporter: admin at seisho.us

Deleting an image from an album with 1K photos requires around 2K queries.
Essentially it reloads the whole album metadata.

Reproducible: Always

Steps to Reproduce:
1.Open an album and start to browser
2.In mysql start to log the query 
SET GLOBAL general_log = 'ON';
SET GLOBAL log_output = 'TABLE';
USE mysql;
TRUNCATE TABLE `general_log`;
3.Delete a photo
4.SET GLOBAL general_log = 'OFF';
select * from general_log;

Actual Results:  
The whole album metadata is reloaded

Expected Results:  
Just the image I'm going to see is refreshed.

You are receiving this mail because:
You are the assignee for the bug.

More information about the Digikam-devel mailing list