[#26483] - [4.0] Improve newsfeed list performance on multilingual sites
- Fixed in Code Base
- 6 Oct 2019
- Medium
- Build: 4.0-dev
- # 26483
- Diff
- SharkyKZ:j4/query/newsfeeds/multilang
- Pending Hound Hound is busy sniffing around... Details
User tests: Successful: Unsuccessful:
Summary of Changes
Replaces JOIN and GROUP clauses in query with a subquery for improved performance.
Testing Instructions
Set up a multilingual site.
Enable language associations.
Create some newsfeeds with and without associations
View newsfeed list in backend.
Expected result
Works like before.
Documentation Changes Required
No.
| Status | New | ⇒ | Pending |
joomla-cms-bot
- | Category | ⇒ | Administration com_newsfeeds |
I have tested this item
Tested with MySQL 5.7 and PostgreSQL 10.10.
About performance I can't say anything because my test data set is too small.
But I can confirm everything works as well as before, carefully watching PHP error log with PHP error reporting set to maximum and watching database log.
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/26483.
@richard67 Changed. Thanks.
I have tested this item
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/26483.
| Status | Pending | ⇒ | Ready to Commit |
RTC
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/26483.
| Status | Ready to Commit | ⇒ | Fixed in Code Base |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2019-10-06 20:38:04 |
| Closed_By | ⇒ | wilsonge | |
| Labels |
Added:
?
|
||
Thanks!
@SharkyKZ Please replace "contact" by "newsfeed" in your description ;-)