Redmine > time_entries slow, very slow! (timeout!!) [RESOLVED]

Good friends!
We had Redmine 3.4.3 and we have migrated to version 5.0.5, we observe that more or less everything works fine, but if I don't choose a project and directly click on Time_entries to see all the logs, Redmine becomes devilishly slow and takes more than 50 seconds to paint the records of time_entries. That in version 3.4.3 did not happen.

We have about 70,000 records in time_entries. its alot?
Should I launch the creation of some index to improve efficiency on that page?

Thank you so much.

Replies (2)

RE: Redmine > time_entries slow, very slow! (timeout!!) - Added by Pavel Rosický 11 months ago

you can profile slow queries with https://dev.mysql.com/doc/refman/8.0/en/explain.html (based on a database you have) but the most likely culprit is https://redmine.org/issues/37268 even with a fix, it's much slower than before

RE: Redmine > time_entries slow, very slow! (timeout!!) - Added by Aitor Consut 8 months ago

We resolved with this patch:
https://www.redmine.org/issues/33431

The migration was successfully.

(1-2/2)

Project

General

Profile

Redmine