What are the Slack Archives?
It’s a history of our time together in the Slack Community! There’s a ton of knowledge in here, so feel free to search through the archives for a possible answer to your question.
Because this space is not active, you won’t be able to create a new post or comment here. If you have a question or want to start a discussion about something, head over to our categories and pick one to post in! You can always refer back to a post from Slack Archives if needed; just copy the link to use it as a reference..
Hello! We are facing huge performance issues in P&S event. Did anyone faced something like that
Hello!
We are facing huge performance issues in P&S event. Did anyone faced something like that? It’s latest product-page-search package.
CC: @UK9N7MP96
Comments
-
Hi Janis,
it looks it failed because of too many repeated columns and conditions, right?0 -
I would guess so. I am not 100% sure. It happens for us in production, we see it failing, but not sure about reason.
0 -
CC: @ULTE9DBGX
0 -
It has really a lot bind parameters. Looks like it is every product. Could be that from somewhere it fetches full catalog, and it basically fails.
0 -
which version of
spryker/event
you have?0 -
did you also check
Propel.log
for an exception, maybe there is more detail0 -
2.5.1
0 -
We don’t have it enabled on production, as it is irrelevant info.
0 -
ok
0 -
It’s clear from the message, that query has way too many bind parameters 5000+
0 -
I think there is an issue regarding queries in shared container, let me check it
0 -
can you check
static::PROPEL_QUERY_PRODUCT_SEARCH
in\Spryker\Zed\ProductPageSearch\ProductPageSearchDependencyProvider
please?0 -
Spryker/Zed/ProductPageSearch/ProductPageSearchDependencyProvider.php:301
0 -
This line will inject
SpyProductSearchQuery
into this module0 -
exactly
return SpyProductSearchQuery::create();
0 -
Exactly ☝
0 -
according to this https://pimple.symfony.com/#defining-factory-services, we might fix it with this code
0 -
0
-
$container->factory
will let this instantiate each time0 -
@ULTE9DBGX can you replace it in
\Pyz\Zed\ProductPageSearch\ProductPageSearchDependencyProvider
please and check it again0 -
let me try
0 -
It is like that already:
0 -
Ahh, ok. Factory
0 -
Never mind.
0 -
Just FYI, also spy_product_search has no index on fk_locale, which makes this query running for more than 40seconds when you have more than 10m rows
0 -
Ok Thanks @ULTE9DBGX I’ll let the core know about the missing index
0 -
we will also release a patch for the cached query object
0 -
@UK9N7MP96 i applied the changes, seems like it’s working fine now
0 -
Great, we are preparing the release, it’s under QA and hope will get done soon 😉
0 -
Nice, thanks
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