MQSeries.net :: View topic - Multiple OracleProcedures calling from a single compute node

indra

Hi

We have a message flow(broker6.0) in which a single compute node
used to invoke 12 procedures(oracle procedures) to interact with oracle 10g database by using a common Data Source Name.
For Instance If 5 requests are send by the client at a time if the database responds within the fraction of seconds than no issue otherwise If the 1st request is delayed from fetching the record
from database than other 4 requests has to be in waiting stage until the first request completes the processing because database connection is made through single compute node.

for above issue Deploying the multiple instances of the same message flow Is this solution optimal because it may arise another problem of session.
or Instead of calling all the procedures from single compute node divert the some of calls to another compute node so that multiple compute nodes can interact with database to speed up the processing.

Is this a good approach for better solution so that simultaneously many requests can be served.

Can anyone suggest better solution for it.

Thanks in Advance...