EAV Model Product - Loading too heavyMagento page loading taking too much timecustom EAV model saving attributesMagento 2 - Heavy loading time (too many js files)Eav Model relationshipHow to inject EAV attribute to product model before loading it in Magento 2?Should I disable flat catalog?Why so many tables for single entity in EAV modelusing addExpressionFieldToSelect for EAV modelCreate custom EAV model in magento 2 extensionGet attribute value of custom eav model in magento 2

Brake pads destroying wheels

Do native speakers use "ultima" and "proxima" frequently in spoken English?

World War I as a war of liberals against authoritarians?

두음법칙 - When did North and South diverge in pronunciation of initial ㄹ?

Probably overheated black color SMD pads

Should I use acronyms in dialogues before telling the readers what it stands for in fiction?

Pronounciation of the combination "st" in spanish accents

Violin - Can double stops be played when the strings are not next to each other?

Is it insecure to send a password in a `curl` command?

Can you move over difficult terrain with only 5 feet of movement?

Word for flower that blooms and wilts in one day

How can an organ that provides biological immortality be unable to regenerate?

Help prove this basic trig identity please!

Why is indicated airspeed rather than ground speed used during the takeoff roll?

Am I eligible for the Eurail Youth pass? I am 27.5 years old

If "dar" means "to give", what does "daros" mean?

When did antialiasing start being available?

Help rendering a complicated sum/product formula

Deletion of copy-ctor & copy-assignment - public, private or protected?

What is the term when voters “dishonestly” choose something that they do not want to choose?

In what cases must I use 了 and in what cases not?

Could Sinn Fein swing any Brexit vote in Parliament?

What is the relationship between relativity and the Doppler effect?

Generic TVP tradeoffs?



EAV Model Product - Loading too heavy


Magento page loading taking too much timecustom EAV model saving attributesMagento 2 - Heavy loading time (too many js files)Eav Model relationshipHow to inject EAV attribute to product model before loading it in Magento 2?Should I disable flat catalog?Why so many tables for single entity in EAV modelusing addExpressionFieldToSelect for EAV modelCreate custom EAV model in magento 2 extensionGet attribute value of custom eav model in magento 2













2















Our website's using Magento 2 platform. Number of product and number of product's attributes keep growing faster.It leads to heavy loading when getting product's information(using EAV Model).In product detail page, we can optimize by indexing the product information to other server. But how can we optimize in checkout flow?. We cannot use flat product table because number of attribute is quite large(limited column in MYSQL table).










share|improve this question









New contributor




user3194608 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
























    2















    Our website's using Magento 2 platform. Number of product and number of product's attributes keep growing faster.It leads to heavy loading when getting product's information(using EAV Model).In product detail page, we can optimize by indexing the product information to other server. But how can we optimize in checkout flow?. We cannot use flat product table because number of attribute is quite large(limited column in MYSQL table).










    share|improve this question









    New contributor




    user3194608 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
    Check out our Code of Conduct.






















      2












      2








      2








      Our website's using Magento 2 platform. Number of product and number of product's attributes keep growing faster.It leads to heavy loading when getting product's information(using EAV Model).In product detail page, we can optimize by indexing the product information to other server. But how can we optimize in checkout flow?. We cannot use flat product table because number of attribute is quite large(limited column in MYSQL table).










      share|improve this question









      New contributor




      user3194608 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.












      Our website's using Magento 2 platform. Number of product and number of product's attributes keep growing faster.It leads to heavy loading when getting product's information(using EAV Model).In product detail page, we can optimize by indexing the product information to other server. But how can we optimize in checkout flow?. We cannot use flat product table because number of attribute is quite large(limited column in MYSQL table).







      magento2 performance eav






      share|improve this question









      New contributor




      user3194608 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.











      share|improve this question









      New contributor




      user3194608 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      share|improve this question




      share|improve this question








      edited 35 mins ago









      Murtuza Zabuawala

      12.6k73362




      12.6k73362






      New contributor




      user3194608 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      asked Mar 12 at 7:26









      user3194608user3194608

      111




      111




      New contributor




      user3194608 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.





      New contributor





      user3194608 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






      user3194608 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.




















          0






          active

          oldest

          votes











          Your Answer








          StackExchange.ready(function()
          var channelOptions =
          tags: "".split(" "),
          id: "479"
          ;
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function()
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled)
          StackExchange.using("snippets", function()
          createEditor();
          );

          else
          createEditor();

          );

          function createEditor()
          StackExchange.prepareEditor(
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: false,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: null,
          bindNavPrevention: true,
          postfix: "",
          imageUploader:
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          ,
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          );



          );






          user3194608 is a new contributor. Be nice, and check out our Code of Conduct.









          draft saved

          draft discarded


















          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f265408%2feav-model-product-loading-too-heavy%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes








          user3194608 is a new contributor. Be nice, and check out our Code of Conduct.









          draft saved

          draft discarded


















          user3194608 is a new contributor. Be nice, and check out our Code of Conduct.












          user3194608 is a new contributor. Be nice, and check out our Code of Conduct.











          user3194608 is a new contributor. Be nice, and check out our Code of Conduct.














          Thanks for contributing an answer to Magento Stack Exchange!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid


          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.

          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f265408%2feav-model-product-loading-too-heavy%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Magento 2 duplicate PHPSESSID cookie when using session_start() in custom php scriptMagento 2: User cant logged in into to account page, no error showing!Magento duplicate on subdomainGrabbing storeview from cookie (after using language selector)How do I run php custom script on magento2Magento 2: Include PHP script in headerSession lock after using Cm_RedisSessionscript php to update stockMagento set cookie popupMagento 2 session id cookie - where to find it?How to import Configurable product from csv with custom attributes using php scriptMagento 2 run custom PHP script

          Can not update quote_id field of “quote_item” table magento 2Magento 2.1 - We can't remove the item. (Shopping Cart doesnt allow us to remove items before becomes empty)Add value for custom quote item attribute using REST apiREST API endpoint v1/carts/cartId/items always returns error messageCorrect way to save entries to databaseHow to remove all associated quote objects of a customer completelyMagento 2 - Save value from custom input field to quote_itemGet quote_item data using quote id and product id filter in Magento 2How to set additional data to quote_item table from controller in Magento 2?What is the purpose of additional_data column in quote_item table in magento2Set Custom Price to Quote item magento2 from controller

          How to solve knockout JS error in Magento 2 Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?(Magento2) knockout.js:3012 Uncaught ReferenceError: Unable to process bindingUnable to process binding Knockout.js magento 2Cannot read property `scopeLabel` of undefined on Product Detail PageCan't get Customer Data on frontend in Magento 2Magento2 Order Summary - unable to process bindingKO templates are not loading in Magento 2.1 applicationgetting knockout js error magento 2Product grid not load -— Unable to process binding Knockout.js magento 2Product form not loaded in magento2Uncaught ReferenceError: Unable to process binding “if: function()return (isShowLegend()) ” magento 2