We have a website that has hundreds dynamic category pages that bring up a list of products by searching relevant products in our database. The problem is that a query from server to database takes 4-6s to return, which increases the load time to 7-9s. Cached pages load very fast in 2-3s even if I visit this page for the first time.
One of the solutions we have is to run the bot every 24 hours and keep those pages cached on the server for 24 hours.
Can anybody see potential negative impact on SEO? Have anybody used similar approach?