Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Have some web app using java, jsp, servlet. too many times frequent queries to oracle 10g under load. Thinking to introduce memcached, Is it simple ? Can it be done without code change? are there any other solutions avaliable?

share|improve this question

No, memcached is a new layer so it will require medium to large code changes.

While there are some fairly simple wrappers that allow minimal code changes they won't make much difference in performance as only a human can tell which queries should actually be cached.

Oracle really requires a good DBA to manage it, if you haven't got one that should be your first step.

Another option, if it's a site for anonymous users would be to use a reverse proxy like Squid or Varnish to cache the full page output instead.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.