Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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