Which is the better options? Pros and cons of each? The web services are meant to be internal-facing and are all going to be roughly in the same datacenter (3-4km apart at most). Any ideas?
I'm creating a service that has read-only access to the database. I have a query cache and a second level cache enabled (READ_ONLY mode) in Hibernate to speed up the service, as the tables being accessed change rarely.
My question is, if someone goes into the DB and changes the tables manually (i.e. outside of Hibernate), does the cache recognize automatically that it needs to be cleared? Is there a time limit on the cache?