api/prodcuts getting very slow

[Megalight]

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?

[devansh-webkul]

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.