Page 1 of 1

Slow: SET ordering on all articles in jos_content upon save

Posted: Tue Jan 22, 2013 1:44 am
by sazli
Hi,

I am running Joomla 1.5.26, and article saving takes longer time if large amounts of articles starts accumulating in jos_content. The reason is a flurry of article reordering occurs:-

UPDATE jos_content SET ordering = 6935 WHERE content_id = '7214';
...... (queries for each content_id).

For now, we had to resort to periodic archiving of older articles and truncating jos_content.

Any other suggestions? Is this the intended behavior, or maybe I have overlooked some settings in joomla admin?

Thanks in advance.

Re: Slow: SET ordering on all articles in jos_content upon s

Posted: Tue Dec 15, 2015 3:06 pm
by HDsportsAT
Do you have found i solution? I have the same problem with J3