Project

General

Profile

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

Added by Aitor Consut 11 months 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ý 10 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 7 months ago

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

The migration was successfully.

    (1-2/2)