I've been wondering how to tackle caching of database calls. Using the Blog component results in about 6 queries being executed and I would like to reduce those since I won't be updating these posts every day. I wondered if there is some way to force caching here. Perhaps I could extend the Blog component and use Eloquent's 'remember' functionality?
And is there any documentation on how October caches pages? Is there a difference between pages that are completely static and ones that use content from a database (like the Blog component)?
The CMS templates are cached (configuration, php and twig sections), then the Twig markup is compiled and cached. Essentially the cache is the same as if you were running a single PHP script. So the database calls are not cached or anything like this.
Perhaps you can submit a Pull Request to improve the database caching?
1-3 of 3