OroCommerce Forums

Covering OroCommerce topics, including community updates and company announcements.

Forums OroCommerce Maximum number of joins – product attributes

This topic contains 1 reply, has 2 voices, and was last updated by Andrey Yatsenko Andrey Yatsenko 2 weeks, 5 days ago.

  • Creator
    Topic
  • #40919

    matthew.brookes
    Participant

    Hi

    i am sorry but i am not very technical, if you need further information please let me know and i will see if i can gather it.

    I have an Oro v3 install and have added nearly 60 different attributes, this caused the product listing to not load due to the maximum number of joins in MYSQL being exceeded. I resolved this by limiting the number of attributes shown on the product listing page within admin.

    However the product export is not working my developer has also written a bespoke Export which is now failing, they have told me they are using the standard Oro product object to gather product data and that the number of joins is being exceed when this is run.

    Is anyone aware of this problem relating to product attributes? Are there any suggestions other than limiting the number of attributes as these are needed during the product export.

    Are they any solutions to this in later releases?

    thanks.

Viewing 1 replies (of 1 total)
  • Author
    Replies
  • #40921
    Andrey Yatsenko
    Andrey Yatsenko
    Moderator

    Hi Matthew,
    Please share the query that fails, or analyze joins by yourself to understand where they come from.
    Usually, depending on the type of attributes developers have the same issue starting from 150-400 attributes. The issue could go with the less number of attributes when most of them are enums (select or multi-select) fields.
    Also, we recommend using serialized fields to store attributes, to do that, when creating new attributes, you should mark as many of them as you can as not filterable and not searchable and use scalar types when you can.

Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.

You will be redirected to [title]. Would you like to continue?

Yes No