I am trying to extract data from the oracle data base using select query(JDBC Adapeter) and writing it to the single file. All the transctions data should be written to single file at the end of the day. The number of transactions per minute is more there will be hectic load on IS(creating thread every time the service runs). How to avoid this issue. ANy suggestions please. I tried by increasing the JDBC pool size. ANy queries pls revert…
“The number of transactions per minute is more there will be hectic load on IS(creating thread every time the service runs).”
This is not accurate. IS does not create a thread to run a service. It uses a thread from a thread pool, which has a configurable size limit, to execute the service. Thus, to handle an increased number of concurrent services being run at any given point you’d increase the thread pool size. The max size will be constrained by the environment such as memory, OS, etc.
Thank you for your reply…