2 Replies Latest reply on May 5, 2006 10:57 AM by Chris Hembrow

    DB JMS performance

    Chris Hembrow Newbie

      We have an application with a queue, through which we are putting thousands of small, very quick, requests. With a non-persistent queue, performance is very good. However, the moment we change to a persistent queue we are seeing huge IO bottlenecks on the JMS tables. This is on Oracle 10g.

      Are there any ways to optimize the performance of this. One possible solution we thought of was to use in-memory tables on Oracle, but we may not be using Oracle long-term anyway.

      Any help is much appreciated, we need the security if persistent queues, but the IO overheads are killing us.