we have a setup of gitea where the action table in the database is currently around 2gigs in size and keeps data for about 3 years. Whenever you load the dashboard page it takes 6 seconds and feels super slow.
My question is what the data is actually used for? I saw that for the dashboard page loads 20 entries, but is it used for anything else important? Can I just deleted a huge bulk of the data?
I also saw that if you would do a different index on the table action (user_id, is_deleted) it would be much faster (91ms instead of 6s) but every restart of gitea resets the table to its original setup. I guess a request regarding that would be then more for the bug ticket area.
Thanks in advance,