Questions tagged [mview]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
13 views

Why aren't Magento sale grids using Mview (and indexer)?

By default Magento implement Mview/indexer for some grids for example customer grid. But for sale grids (sale, invoice, credit memo, shipment) Magento use a cron job to insert/update new data (if ...
user avatar
1 vote
1 answer
201 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, ...
user avatar
  • 3,036
6 votes
2 answers
3k 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 ...
user avatar
  • 195k
2 votes
1 answer
838 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 ...
user avatar
  • 195k
40 votes
3 answers
17k views

What is mview in Magento 2?

First of all what I know : Index management is useful for increasing store performance. EAV has one disadvantage.it will store data in different tables. So that retrieving data is time-consuming. So ...
user avatar
  • 1,995
7 votes
2 answers
3k 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....
user avatar