search

mage2tv / topics

Discussion and voting on future and existing mage2.tv topics.
27 stars 1 forks source link

[Indexing] ORM Entity Indexing #158

Open Vinai opened 7 years ago

vy-shmal commented 5 years ago

Does creating a custom indexer counts for this issue ?

If yes then +1

Vinai commented 5 years ago

Hi @vy-shmal, yes it would. However, I have to admit that in my work with Magento 2 so far I have never had the need to create a custom indexer. Can you describe the use case maybe? That would help me make the video.

vy-shmal commented 5 years ago

Hi @Vinai , indeed nether do I have created any custom index, but mostly because I had not so much knowledge about this subject.

Regarding the case you asked, at our company we have a customer that has some tables with lots of rows. One have the zip codes of all the country , the other one have rows with shipping prices and many more custom fields, another one table with more custom fields , like time and stuff. The core functionality is to calculate the available dates and prices for a zipcode .

Every time the functionality is used, it has to access all these tables, which I think if it was one table with indexed data this functionality would be faster. Or maybe these functionality , was badly written from the beginning .