<meta http-equiv="Content-Type" content="text/html; charset=utf-8"><div dir="auto">How slow are we talking?<div dir="auto"><br></div><div dir="auto">I have used the tag manager to highlight and delete unused tasks and it takes a few seconds at most. Can't you just leave it for a few minutes until the process is done?</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Aug 2, 2022 10:37, Glen <glen@glenvision.com> wrote:<br type="attribution"><blockquote class="quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div>
<p><span style="color:rgb( 46 , 52 , 54 );font-family:'sans' 'helvetica neue' sans-serif;font-size:13.3px;font-style:normal;font-weight:400;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb( 255 , 255 , 255 );display:inline !important;float:none">I removed over 200,000 images from my
database. I'm now left with thousands and thousands of unused
tags. Deleting all the unused tags is proving to be
excruciatingly slow and painful. Even using Tag Manager to
merely highlight all the unused tags is unacceptably slow.</span><br style="color:rgb( 46 , 52 , 54 );font-family:'sans' 'helvetica neue' sans-serif;font-size:13.3px;font-style:normal;font-weight:400;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb( 255 , 255 , 255 )">
<br style="color:rgb( 46 , 52 , 54 );font-family:'sans' 'helvetica neue' sans-serif;font-size:13.3px;font-style:normal;font-weight:400;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb( 255 , 255 , 255 )">
<span style="color:rgb( 46 , 52 , 54 );font-family:'sans' 'helvetica neue' sans-serif;font-size:13.3px;font-style:normal;font-weight:400;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb( 255 , 255 , 255 );display:inline !important;float:none">Is there any way to speed up the
deletion of unused tags from my database?</span><br style="color:rgb( 46 , 52 , 54 );font-family:'sans' 'helvetica neue' sans-serif;font-size:13.3px;font-style:normal;font-weight:400;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb( 255 , 255 , 255 )">
<br style="color:rgb( 46 , 52 , 54 );font-family:'sans' 'helvetica neue' sans-serif;font-size:13.3px;font-style:normal;font-weight:400;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb( 255 , 255 , 255 )">
<span style="color:rgb( 46 , 52 , 54 );font-family:'sans' 'helvetica neue' sans-serif;font-size:13.3px;font-style:normal;font-weight:400;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb( 255 , 255 , 255 );display:inline !important;float:none">I'm using digiKam with MariaDB, on a
Windows 10 system. My database resides on the computer's primary
hard drive, which is an SSD. Despite the database being located
on an SSD, tag deletion is still painfully slow, I expect this
process will take me multiple days to complete. In the meantime,
I can't use digiKam for any other purposes while Tag Manager is
busy deleting all those tags, and I really need to keep using
digiKam for other purposes on a daily basis.</span><br style="color:rgb( 46 , 52 , 54 );font-family:'sans' 'helvetica neue' sans-serif;font-size:13.3px;font-style:normal;font-weight:400;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb( 255 , 255 , 255 )">
<br style="color:rgb( 46 , 52 , 54 );font-family:'sans' 'helvetica neue' sans-serif;font-size:13.3px;font-style:normal;font-weight:400;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb( 255 , 255 , 255 )">
<span style="color:rgb( 46 , 52 , 54 );font-family:'sans' 'helvetica neue' sans-serif;font-size:13.3px;font-style:normal;font-weight:400;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb( 255 , 255 , 255 );display:inline !important;float:none">Does anyone know how to speed up
unused tag deletion?</span><br style="color:rgb( 46 , 52 , 54 );font-family:'open sans' , 'helvetica neue' , 'helvetica' , 'arial' , sans-serif;font-size:13.3px;font-style:normal;font-weight:400;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb( 255 , 255 , 255 )">
<br style="color:rgb( 46 , 52 , 54 );font-family:'sans' 'helvetica neue' sans-serif;font-size:13.3px;font-style:normal;font-weight:400;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb( 255 , 255 , 255 )">
<span style="color:rgb( 46 , 52 , 54 );font-family:'sans' 'helvetica neue' sans-serif;font-size:13.3px;font-style:normal;font-weight:400;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb( 255 , 255 , 255 );display:inline !important;float:none">Should I be using some sort of other
software tool, perhaps a database-specific tool, instead of the
digiKam Tag Manager?</span></p>
</div>
</blockquote></div><br></div>