有没有办法让 Magento 索引更加智能?
我想知道是否可以制定一种新方法来仅更新自从我运行 core_url_rewrite 表中包含 206000 条记录的商店以来已更改的产品的索引,并且需要每天更新产品状态。
使用 CLI 调用 index.php --reindex Catalog_url 需要 8 小时。
I would like like to know if it is possible to make a new method to only update indexes on products which have changed since I run a store with 206000 records in the core_url_rewrite table and need to update product status everyday.
It takes 8 hours using a CLI call to index.php --reindex catalog_url.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
侦听
catalog_product_save_after
事件并在需要更新时更新各个行,这样您就不必每天执行完整索引。事实上,这是应该已经发生的事情,所以想一想,你在做什么打破了这一点?Listen for the
catalog_product_save_after
event and update individual rows as they need updating, that way you won't have to perform full indexing everyday. Actually this is what's supposed to already happen so think, what are you doing that breaks this?