I have a WP-site with not that many writes, but quite a few reads and a few specific hotspots in the templates that I'd like to cache pretty aggressively with my own PHP-caching mechanism.
I could implement this with a time-based cache expiration scheme, but as I'm sure Wordpress provides all the API I need for listening to different events, I could also hook into them for info on when I need to clear caches.
So, I'm a bit lost on the whole hooks / filters -thingy of Wordpress. I can add listeners to hooks easily enough, but I'm just a bit too overwhelmed with the amount of hooks available, so my question is:
What hooks should I hook into to basically be able to execute a script upon every INSERT / UPDATE / DELETE operation on the posts-table?
Any pointers on the way onward are much appreciated!