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.
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

Postby 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: 151
Joined: Fri Oct 24, 2014 8:26 am
Contact:

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

Postby HDsportsAT » Tue Dec 15, 2015 3:06 pm

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


Return to “Performance - Joomla! 1.5”

Who is online

Users browsing this forum: No registered users and 2 guests