Feeling Lucky
?
[#26482] - [4.0] Improve contact list performance on multilingual sites
- Fixed in Code Base
- 6 Oct 2019
- Medium
- Build: 4.0-dev
- # 26482
- Diff
- SharkyKZ:j4/query/contacts/multilang
- Pending Hound Hound is busy sniffing around... Details
User tests: Successful: Unsuccessful:
Pull Request for Issue # .
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 contacts with and without associations
View contact list in backend.
Expected result
Works like before.
Documentation Changes Required
No.
| Status | New | ⇒ | Pending |
joomla-cms-bot
- | Category | ⇒ | Administration com_contact |
alikon
- comment
- 6 Oct 2019
I have tested this item
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/26482.
| Status | Pending | ⇒ | Ready to Commit |
alikon
- comment
- 6 Oct 2019
RTC
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/26482.
| Status | Ready to Commit | ⇒ | Fixed in Code Base |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2019-10-06 20:47:12 |
| Closed_By | ⇒ | wilsonge | |
| Labels |
Added:
?
|
||
wilsonge
- comment
- 6 Oct 2019
Thanks!
I have tested this item✅ successfully on 399b681
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/26482.