Joomla JTable排序功能可运行数千个查询 [英] Joomla JTable ordering function runs thousands queries

问题描述

当我在类别中创建新文章时，joomla开始重新排序整个类别，甚至是已归档的文章. 负责此操作的代码是jTable重排序功能(libraries/joomla/table/table.php)，该功能选择相同类别的所有记录，然后对于每个，通过一次查询重置排序值.

When I create a new article in a category, joomla starts to reorder the whole category, even the archived articles. The code responsible of this is the jTable reorder function (libraries/joomla/table/table.php) which selects all the records of the same category and then, for EACH ONE, reset the ordering value with a single query.

我的类别包含15,000篇文章，其中99％已存档.

My category contains 15k articles, 99% of them archived.

因此，当我将文章保存在该类别中时，我必须等待15k +次查询，这需要很多时间！

So when i save an article in that category I have to wait 15k+ queries, which takes a lot!

问题是.为什么???你有同样的问题吗?有解决办法吗?

The question is. Why??? Have you the same problem? Any solution?

注意: 我有最新版本的Joomla 3.5，但问题是从某些版本开始的.

Notes: I have Joomla 3.5, the latest one, but the problem started some versions ago.

推荐答案

GitHub上有一个补丁试图仅针对MySQL平台解决此问题，请参见

There is a patch on GitHub that tries to address this only for MySQL platforms, see https://github.com/joomla/joomla-cms/pull/8563

这篇关于Joomla JTable排序功能可运行数千个查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！