[#13868] - To many elements to index
- Fixed in Code Base
- 24 May 2018
- Medium
- Build: staging
- # 13868
- Diff
- tomekstach:patch-1
User tests: Successful: Unsuccessful:
I don't know why in the query #__tags is twice. Once as a a and second time as a b. For me it works perfectly when we remove b. I had a problem with this - for 1100 tags on my websites, Smart Search Indexer found more than 1233000 items to index.
Pull Request for Issue #13866.
Summary of Changes
Remove #__tags AS b from the query and change the b.created_user_id to the a.created_user_id in the JOIN part of the query.
Testing Instructions
Use php cli/finder_indexer.php to check if the number of tags is the same as a number of items to index.
Expected result
For the number of tags have the same number of items for index.
Actual result
For 1100 tags, I have more than 1233000 items to index.
Documentation Changes Required
| Status | New | ⇒ | Pending |
joomla-cms-bot
- | Category | ⇒ | Front End Plugins |
| Labels |
Added:
?
|
||
I have tested this item
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/13868.
I have tested this item
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/13868.
| Status | Pending | ⇒ | Ready to Commit |
RTC
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/13868.
I have tested this item
Tag indexing works properly
and
before PR we get FROM #__tags AS a, #__tags AS b
a million rows to index for 1000 tags
SELECT a.id, ...
FROM #__tags AS a, #__tags AS b
LEFT JOIN #__users AS u ON u.id = b.created_user_id
WHERE `a`.`id` > 1After PR FROM #__tags AS a
1000 rows to index for 1000 tags
SELECT a.id, ...
FROM #__tags AS a
LEFT JOIN #__users AS u ON u.id = a.created_user_id
WHERE `a`.`id` > 1This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/13868.
mbabker
- | Status | Ready to Commit | ⇒ | Fixed in Code Base |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2018-05-24 00:06:28 |
| Closed_By | ⇒ | mbabker | |
| Labels |
Added:
?
|
||
I can confirm this issue and tested this item successfully.