Slow: SET ordering on all articles in jos_content upon save

Discussion regarding Joomla! 1.5 Performance issues.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Security and Performance FAQs
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Locked
sazli
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Mon Oct 02, 2006 4:39 pm

Slow: SET ordering on all articles in jos_content upon save

Post by sazli » Tue Jan 22, 2013 1:44 am

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.

 
HDsportsAT
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 170
Joined: Fri Oct 24, 2014 8:26 am
Contact:

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

Post by HDsportsAT » Tue Dec 15, 2015 3:06 pm

Do you have found i solution? I have the same problem with J3
My Joomla-site: www.HDsports.at

 

Locked

Return to “Performance - Joomla! 1.5”