?
avatar ch2856
ch2856
25 Oct 2016

Steps to reproduce the issue

Creat an new article on a category with 1000s or more articles, first saving time takes about 10 sec.

Expected result

2-3 sec for saving an article. It was fixed on j3.6.1 (or 3.6.2, don't remember) but now it's back.

Actual result

System information (as much as possible)

j3.6.4 php 5.x on NGINX server

Additional comments

Votes

# of Users Experiencing Issue
0/1
Average Importance Score
3.00

avatar ch2856 ch2856 - open - 25 Oct 2016
avatar ggppdk
ggppdk - comment - 25 Oct 2016

This was discussed here: #10567 Save new article (create a new ID) very slow in category with many articles

  • it is the performance of JTable::reorder()

A patch was made to use last ordering: #8576 Performance gain - new featured article

  • that (partially) fixed the performance issue (it fixed it for new articles only, but it did not fix in the general re-order case)
  • at the same time this was problematic , since users with many articles will have to manually move the new articles many positions to place them to the top

Then it was reverted here: #11581 Revert "Performance gain - new featured article"

The revert was supposed (?) to be made together with a performance fix like for example this one:
#11184 Reorder tables with single SQL query (all DBs compatible), greatly improving reorder performance

(other performance fixes (PRs) were proposed too)

But only a revert was made in J3.6.3+ without adding any fix for JTable::reorder()

avatar franz-wohlkoenig
franz-wohlkoenig - comment - 5 Apr 2017

@ch2856 ist this Issue solved?


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/12552.

avatar joomla-cms-bot joomla-cms-bot - change - 5 Apr 2017
The description was changed
avatar joomla-cms-bot joomla-cms-bot - edited - 5 Apr 2017
avatar franz-wohlkoenig franz-wohlkoenig - change - 5 Apr 2017
Status New Information Required
avatar ch2856
ch2856 - comment - 5 Apr 2017

Nope, it's not solved yet. It takes about 30 second to save an article. I solved it with saving to other category and then save it again to the right one.


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/12552.

avatar joomla-cms-bot joomla-cms-bot - change - 5 Apr 2017
The description was changed
avatar joomla-cms-bot joomla-cms-bot - edited - 5 Apr 2017
avatar franz-wohlkoenig franz-wohlkoenig - change - 6 Apr 2017
The description was changed
Priority Medium Low
Status Information Required Needs Review
avatar franz-wohlkoenig
franz-wohlkoenig - comment - 6 Apr 2017

thanks for Info. Set Status "Needs Review" on Issue Tracker.

avatar mbabker
mbabker - comment - 25 May 2017

@ch2856 Was your last test against the (at the time) 3.6.5 stable or 3.7 beta/RC releases? Presumably this should have been addressed in 3.7.

avatar Quy
Quy - comment - 6 Dec 2017

@ch2856 Please advise if this is still an issue with the latest version.

avatar Quy
Quy - comment - 28 Dec 2017

@franz-wohlkoenig Close due to no response?

avatar ggppdk
ggppdk - comment - 28 Dec 2017

@Quy, i think close because it was fixed,
the reorder performance issue was fixed by @csthomas PR #13505

avatar Quy Quy - change - 28 Dec 2017
Status Needs Review Closed
Closed_Date 0000-00-00 00:00:00 2017-12-28 05:45:21
Closed_By Quy
avatar joomla-cms-bot joomla-cms-bot - change - 28 Dec 2017
Closed_By Quy joomla-cms-bot
avatar joomla-cms-bot joomla-cms-bot - close - 28 Dec 2017
avatar joomla-cms-bot
joomla-cms-bot - comment - 28 Dec 2017

Set to "closed" on behalf of @Quy by The JTracker Application at issues.joomla.org/joomla-cms/12552

avatar Quy
Quy - comment - 28 Dec 2017

Closed as stated and no followup response by OP.


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/12552.

Add a Comment

Login with GitHub to post a comment