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.