Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

\Yotpo\Yotpo\Model\Richsnippet::getSnippetByProductIdAndStoreId does not use an index #284

Open
steven-hoffman-jomashop opened this issue Feb 3, 2022 · 0 comments

Comments

@steven-hoffman-jomashop
Copy link

The lookup is by store_id and product_id.
The only index on the table is the primary key.
There should be an index on store_id,product_id so that the lookup should be fast.
(There is no need to scan the entire table).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant