Very Slow Product View in Odoo Website
We have our website running in Odoo, all of the features are running fast except our products and clearance tab. It takes about 12-13 seconds for the products of the first page to load (there is only 20 products displayed). But, we have 2900 in total published.
It takes 12-13 seconds for a non-user to visit the products tab, however, when I am logged into the administrator account it takes up to 30 seconds for the products page to load. The same amount of time is taken to move from page 1, 2, 3.. etc within the products page.
We updated our postgreSQL version, but, no change in speed. It almost seems that we are loading all 7500 of our products every time we click products or go to the next page.