Product validity table cleanup
\Spryker\Zed\ProductValidity\Persistence\ProductValidityQueryContainer::queryProductsBecomingInvalid queries db table spy_product_validity for items that are valid_to < now.
But is this table ever cleaned up anywhere?
From what I can tell, the check-product-validity Jenkins job runs every hour (or whenever it's set up to run), does the above query, sets the resulting products as inactive and… that's it. The spy_product_validity table is untouched, and the next job run does the same things all over again.
Best Answer
-
fsmeier Senior Software Engineer & Developer Enablement Advocate Sprykee Posts: 1,052 ⚖️ - Guardians (admin)
Heyhey,
so I checked the code and I would say so as well. Overall Spryker rarely deletes any product related data ootb.So this table grows over time….
Likely not the answer you wish for, yet: If you run into performance issues because of this I ask you kindly to create an official support ticket so the problem is being tracked.
All the best,
Florian
1
Answers
-
fsmeier Senior Software Engineer & Developer Enablement Advocate Sprykee Posts: 1,052 ⚖️ - Guardians (admin)
Heyhey,
so I checked the code and I would say so as well. Overall Spryker rarely deletes any product related data ootb.So this table grows over time….
Likely not the answer you wish for, yet: If you run into performance issues because of this I ask you kindly to create an official support ticket so the problem is being tracked.
All the best,
Florian
1 -
Thanks Florian! I'll probably add an isActive-check to the query and make an official ticket about this Sometime™ when I have time :)
1
Categories
- All Categories
- 42 Getting Started & Guidelines
- 7 Getting Started in the Community
- 8 Additional Resources
- 7 Community Ideas and Feedback
- 68 Spryker News
- 890 Developer Corner
- 753 Spryker Development
- 83 Spryker Dev Environment
- 360 Spryker Releases
- 3 Oryx frontend framework
- 34 Propel ORM
- 68 Community Projects
- 3 Community Ideation Board
- 30 Hackathon
- 3 PHP Bridge
- 6 Gacela Project
- 22 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
- 68 Spryker Safari Questions
- 50 Random