Product-Relation Update taking very long
Hello fellow Sprykees,
we are currently investigating an issue in a customer-project.
The Jenkins job "product-relation:update" is taking ~11 hours, up from was previously ~5 hours, which is still a long runtime considering no problems in other projects.
The command wasn't overwritten, other than 2 indexes on "fk_product_abstract" and "fk_product_relation_type".
Did anyone else encounter similiar issues and could help?
Comments
-
A known problem and communicated for approx. 4 years to Spryker but nothing has been improved. The only thing I recommend is to optimize the business logic with bulk and CTE and no more..
There are several other problems in Feature Product-Relation:
- missing indexes
- really trivial logic that only works with a couple hundred items but not with millions of items (e.g. the is_rebuild_scheduled flag is catastrophic logic)
- and maybe propel just doesn't seem to be suitable for this kind of massive operations in db
- etc.
What I suggest you change right away is precisely how the is_rebuild_scheduled flag works. Then it depends on whether you have dynamic query sets or well-defined sku lists. On that depends a bit!
2 -
fsmeier Senior Software Engineer & Developer Enablement Advocate Sprykee Posts: 1,081 ⚖️ - Guardians (admin)
Heyhey,
for better visibility i'll move this topic into the general Spryker category and out of the development environment sub-category :)
All the best,
Florian
0
Categories
- All Categories
- 42 Getting Started & Guidelines
- 7 Getting Started in the Community
- 8 Additional Resources
- 7 Community Ideas and Feedback
- 75 Spryker News
- 924 Developer Corner
- 783 Spryker Development
- 88 Spryker Dev Environment
- 362 Spryker Releases
- 3 Oryx frontend framework
- 35 Propel ORM
- 68 Community Projects
- 3 Community Ideation Board
- 30 Hackathon
- 3 PHP Bridge
- 6 Gacela Project
- 25 Job Opportunities
- 3.2K 📜 Slack Archives
- 116 Academy
- 5 Business Users
- 370 Docker
- 551 Slack General
- 2K Help
- 75 Knowledge Sharing
- 6 Random Stuff
- 4 Code Testing
- 32 Product & Business Questions
- 70 Spryker Safari Questions
- 50 Random