Deleting many entries in a large database takes way too long

[ThiloteE]

JabRef 5.7--2022-06-15--cb5fe60
Linux 5.4.0-120-generic amd64
Java 18.0.1
JavaFX unknown

Tried to reproduce #5071 (comment)

Took me ca. 1-4 minutes to even select 7360 entries from my 100 000 entries database (15,5 mb) with CTRL+Shift+PageUp. This was a lot faster than CTRL+Shift+Up by the way. I don't want to know how long it will take to select 7000 entries with CTRL+Shift+Up....

Then i tried to delete 7360 entries: Used my stop watch to count: 1 hour, 37 minutes ... + X. Did a force close, because I don't want this PC to run at max capacity for hours. Just to delete a simple text in a text-file this seems a little bit over the top.

CPU was pretty high. RAM was normal and stable.

This was done with an old laptop from 2013: Aspire E13 (ES1-311-P87D), the HDD was replaced with a SSD at one point.

Originally posted by @ThiloteE in #5071 (comment)

[ThiloteE]

meta-issue: #8906

[ThiloteE]

@ilippert @AEgit tagging you, because this issue was originally raised by you both, so you can keep track of this :-)

[AEgit]

Sorry for the delayed reply and thanks for creating a new issue. Issue is also mentioned here: #5071 (comment) (but better to keep it as a separate new issue, to avoid having to read the long thread).

[Zurtar]

/assign-me

[github-actions]

👋 Hey @Zurtar, thank you for your interest in this issue! 🎉

We're excited to have you on board. Start by exploring our Contributing guidelines, and don't forget to check out our workspace setup guidelines to get started smoothly.

In case you encounter failing tests during development, please check our developer FAQs!

Having any questions or issues? Feel free to ask here on GitHub. Need help setting up your local workspace? Join the conversation on JabRef's Gitter chat. And don't hesitate to open a (draft) pull request early on to show the direction it is heading towards. This way, you will receive valuable feedback.

Happy coding! 🚀