https://bugs.kde.org/show_bug.cgi?id=468622

            Bug ID: 468622
           Summary: A slow connection while using a remote database or
                    collection causes digikam to freeze or become
                    unresponsive
    Classification: Applications
           Product: digikam
           Version: 8.0.0
          Platform: unspecified
                OS: All
            Status: REPORTED
          Severity: normal
          Priority: NOR
         Component: Database-Mysql
          Assignee: digikam-bugs-n...@kde.org
          Reporter: michael2macdon...@gmail.com
  Target Milestone: ---

SUMMARY
When using a remote MySQL database over a slow connection, such as a VPN,
Digikam will often freeze or become unresponsive for long periods while
navigating/changing albums and performing operations.

STEPS TO REPRODUCE
1. Setup Digikam with a remote mysql database
2. Connect using a slow connection such as a VPN
3. Try booting Digikam, loading a large album, or performing a large operation
such as scanning for new items and generating thumbnails for new items.

OBSERVED RESULT
Digikam will freeze, often for a few minutes or until the operations (scanning
/ generating thumbnails) have been completed, and Digikam becomes unresponsive.
Performing any background operations is practically impossible while remote
because digiKam will be frozen and unusable while they complete. It becomes
impossible to cancel an operation after it has started due to the UI being
unresponsive. Digikam is almost unuseable while remote, even for light tasks,
because of how slow it becomes to navigate.

EXPECTED RESULT
Digikam should stay responsive while background operations (such as scans and
thumbnail generation) are happening. When the UI is waiting on information from
the remote DB or remote album, it should stay responsive and a loading icon
should display to indicate that it is working on loading the page/album. While
loading a UI page or album, the user should be able to cancel the loading
operation by navigating to a different page/album instead of having to wait for
the current page to load and the UI to become responsive again before they can
navigate away.

ADDITIONAL INFORMATION
I have a large library of photos (both on my laptop and on a NAS in my home)
and I use OpenVPN to access my NAS and database while away from home. Both my
local albums on my laptop and my remote albums on the NAS are slow when I am
away from home and using a VPN. I also use a local database file on my laptop
for thumbnails so I believe that the (main) bottleneck is the remote database
which causes the freezes.

I think that somehow running database and background operations in a separate
thread and adding a loading icon/screen/popup/window instead of freezing the
entire UI would make Digikam much more usable and user-friendly.

*Quick note: I understand the limitations of my VPN and network speed, and that
a slow connection will always make loading and operations slower. But having to
wait for Digikam to load after every click before I can click something else
and not being able to immediately navigate away if I click on the wrong thing
makes Digikam unusable while working remotely. It also makes doing any
background operations impossible while remote because digiKam will be unusable
until they are complete.

-- 
You are receiving this mail because:
You are watching all bug changes.

Reply via email to