[KPhotoAlbum] EXIF database location not in picture root, please.

[Robert Krawitz]

On Fri, 18 Nov 2016 10:07:15 +0100 (CET), Harald Barth wrote:
>
> Where do I need to change to put the EXIF database in another
> location? What't im curreltly running (some GIT snapshot from Apr 7)
> completely kills network file system performance, I don't have the
> time to wait > 48h for a complete EXIF db regeneration to complete.
> It's not the 57k pictures that's the problem, it's the database file
> accesses.

This should have been fixed in January (and my tests indicate that it
was fixed).  Take a look at Exif/Database.cpp; in
Exif::Database::recreate() there should be a call to
m_db.transaction(), with m_db.commit() called near the end.

Author: Johannes Zarl-Zierl <johannes at zarl-zierl.at>  2016-01-21 10:03:00
Committer: Johannes Zarl-Zierl <johannes at zarl-zierl.at>  2016-01-21 10:03:00
Parent: 9604ba16669078f77101f0187dfccd796b89e15e (Exif::Database::insert: reuse query string.)
Child:  744cb800dd12ebb6802704931eccc826ea67459c (Code cleanup.)
Branches: kf5-port, master, remotes/origin/4.7, remotes/origin/5.x, remotes/origin/category_settings_fix, remotes/origin/kf5-port, remotes/origin/master
Follows: v4.7
Precedes: v4.7.1

    Use a transaction in Exif::Database::recreate().
    
    The main limiting factor in building the exif database until now was the
    exif database file getting overwhelmed with queries.
    
    Thanks to Robert Krawitz, who did a detailed performance analysis and
    reported the potential speedup in this area.
-- 
Robert Krawitz                                     <rlk at alum.mit.edu>

***  MIT Engineers   A Proud Tradition   http://mitathletics.com  ***
Member of the League for Programming Freedom  --  http://ProgFree.org
Project lead for Gutenprint   --    http://gimp-print.sourceforge.net

"Linux doesn't dictate how I work, I dictate how Linux works."
--Eric Crampton