Symfony - caching database result sets

Question

I use the symfony framework and I’m trying to find a way to significantly reduce the reading of the database, I heard about the use of caching to service the data that is accessed very often, and the cache is updated when the data is updated, that’s almost all I know about the subject, I am archiving the data into another table and using the views to combine the two tables to get the two tables joined (for example: - tournament_current contains the current tournament data, tournament_current contains data from past tournaments, a view called about edineniem tournaments, and shows the union of two tables). I need to cache tables / views (?) To avoid multiple readings of the database for the same immutable data, so caching caching and caching the database (?) Would be very useful.

since I implement this in symfony

• Is there an easy to use package?
• Can i store cache files on amazon s3?
• is there any simple xml based solution on this? if so, how does this compare to symfony caching?
• I need these methods for compatibility with postgreSQL and doctrine.

Answer 1

Are you looking for a "second level cache"

You do not need an additional package - it is in the doctrine, you just need to configure it.

http://docs.doctrine-project.org/projects/doctrine-orm/en/latest/reference/second-level-cache.html