Questions tagged [mview]
The mview tag has no usage guidance.
7
questions
0
votes
0answers
25 views
How to relate an entity type to an entity_id within an indexer's mview changelog?
I am trying to contribute to some performance enhancements on the indexing of my website. I'm having an issue knowing which entity types are being referred to in the changelog (*_cl) tables.
As a ...
0
votes
0answers
11 views
Update on Schedule execute indexer multiple time
I have created a custom indexer in my project and configured it to work on 'Update on Schedule'. It is working fine but I have observed, it is executed multiple times even if there is no change in the ...
1
vote
1answer
81 views
How to call Magento2 mview reindexer programmatically
I have line of code which schedule full or partial reindex cron job.
using Trigger::REINDEX_SCOPE_PARTIAL and Trigger::REINDEX_SCOPE_FULL parameter.
public function restoreIndexers($reindex = false, ...
5
votes
2answers
1k views
Deleting values from `_cl` tables
This is a 2 part question.
Main question:
How risky is to delete the records from the *_cl tables (cataloginventory_stock_cl, catalog_product_attribute_cl, ...) where the version_id field is lower ...
2
votes
1answer
463 views
Remove trigger creation when changing an indexer mode
I've disabled the Magento_Bundle module because I don't need it.
But now when I try to set the catalogsearch_fulltext index to schedule via cli:
php bin/magento indexer:set-mode schedule ...
33
votes
3answers
12k views
what is mview in magento2?
First of all what i know :
Index management is useful for increasing store performance.
EAV has one disadvantage.it will store data into different tables.so that retrieving data is time consuming.
...
7
votes
2answers
2k views
Custom indexer on Magento2
I'm trying to create a custom indexer on Magento2.
I defined a mview.xml and one indexer.xml as follows:
indexer.xml:
<?xml version="1.0" encoding="UTF-8"?>
<config xmlns:xsi="http://www....
