Project

General

Profile

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

Added by Aitor Consut over 1 year ago

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ý over 1 year 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 about 1 year ago

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

The migration was successfully.

    (1-2/2)