I would like to periodically (via a schedule) change the content on the home page for a client. They have many Case Studies and Testimonials. I realize I can randomly query from tables to do this, but it slows the home page loading. Ideally I would like do this on a daily or weekly basis to (hopefully) get SEO benefits, but more importantly speed the actual page load as it would not have to perform two separate queries to load the page. This also means my client wouldn’t have to periodically do this themselves or pay me to do it.
I know how to write server side, batch scripts, query the DB etc., but I have not found a way to reference fields on a specific page and their content via a batch script. Maybe I am missing something obvious and simple?
I am hoping (speculating) that such changes if done from the back-end will still appear on the published site, but that maybe another question.
Any thoughts, pointer, or suggested areas to investigate are appreciated.