I am working on a Business Intelligence projects, it has a large number of records, 4.6 million companies and 80 million directors. Currently I am replacing the full text queries with Elastic Search ones.
Once this is done, I need to cache the web pages, the data only changes in frequently e.g once every 12 months or so, so the page itself is best being cached rather than the database.
What is the best cache solution? Currently the server uses Varnish but this only caches the non dynamic page elements so actually doesn't help much in this scenario.
I've looked at fastcgi which seems suitable but I am not familar with this area only that caching is needed.
What is the best web cache solution in this situation?
Thanks - still a novice so bear with me!