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.