Deleting Dupes - Deleting is very slow
Closed this issue · 3 comments
Halo
I have some thousands of bookmarks in my Firefox on Ubuntu, Windows (2 devices), Mac and Android devices.
All with sync enabled.
But for the DupeDeleting I disabled Sync in FF 111.0.1 (Ubuntu 22.04 at the moment).
Many dupes because of wrong sync I guess.
I tried this Add-On to delete the duplicates, but it is incredibly slow.
After half an hour I read:
(3 %) 74 von 2566 Lesezeichen entfernt
Is this normal or can I enhance it somehow?
Like this it will be finished tomorrow, slowing down FF as well, so I cannot use it.
Thanks.
frank
EDIT: maybe I could run the SQL command directly on the places.sqlite DB?
Then I would quit FF and run that command it in e.g. DBeaver or on command line, but there is no visible logfile in the add-on, where I could see what is done in background.
Here a screenshot before deleting:
Here when I start deleting:
And here after about 10 minutes deleting, makes FF very slow:
Oh oh!
And here, after I disabled some other Add-Ons (Bookmark Notes, Bookmark Search Plus 2 and Bookmark Organizer) only some seconds after starting it:
Sorry, that was house made 😊
Close it.
EDIT: and already finished:
2447 Lesezeichen gelöscht
Normally, the deletion is quite fast (in the range of hundreds of bookmarks per seconds).
I had reports about slow deletions which turned out to be caused by completely broken bookmark databases.
Another reason might be lack of memory (frequent garbage collection).
The extension just calls the javascript methods for bookmark deletions - that's all it has permissions to.
Manually accessing the database with sqllite is probably not a good idea as this will presumably not play well with syncing.
BTW, this might be another reason for the slow processing, if for some reason firefox thinks that it has to sync very frequently.
Sorry, I have closed already, we wrote the same time.
Issue solved, it was obviously the other Bookmark Add-Ons (see above) which made it slow.
Thanks for the fast reply and the great and useful Add-On ❤️
By the way, my places.sqlite is very crowdy and maybe not optimized and even partly broken. I had for a long time big issues with sync on Mac but since a while sync works again on Mac, I guess something serverside was fixed to handle errors or such.
But I have too much bookmarks to clean them manually.
A big thing was, when Moz stopped the description field in bookmarks, about FF 60 something, I depended a lot on that.
Never found a replacement for the personal comment field (where I noted a lot).