https://bugs.kde.org/show_bug.cgi?id=431951
--- Comment #16 from griffiths_a...@icloud.com --- Well, I can say with a small amount of confidence that I think my issue is related to my MySQL db. I have completed the MySQL to SQLite conversion overnight, and I'm now trying it out in both my own compiled binary and in the appimage. Performance is now very good in both. There are no hangups while scrolling or selecting. I have a total of 402,000 files in the db which gave a 10GB thumbnail table and 620MB ImageHaarMatrix table in the old MySQL db. Total image size is probably 4TB+. Obviously I haven't got a comparison yet in the SQLite db until the thumbnail db is populated, and I've yet to try face recognition again. Would it be safe to say that my old db was severely underperforming and full of redundant data (despite regular db maintenance)? I've been using it since 6.4 IIRC. If I get the time I'm going to try a MySQL to MySQL conversion and see whether there is any comparison in table sizes over time. For the moment though, I'll continue with the new db and see whether running face recognition (and retagging ofc unfortunately as that was lost) has any detrimental effect. I don't think I need to do any tests for GDB backtraces. Gilles & Maik, Thanks for your help and guidance so far! -- You are receiving this mail because: You are watching all bug changes.
