api/prodcuts getting very slow

  • When I get products via api/products, I got results after 2 seconds, call into bagsito demo store to get api/products get 1.8 seconds it's very slow. How can we optimize this result?

  • Hi @Megalight,

    There is a product_attribute_values table which takes more time.

    If you don't have to work with the attribute and that attribute is already present in the product_flat table then you can use the product_flat table so that maximum join queries can be avoided.

Log in to reply