3 Replies Latest reply: Jun 21, 2013 8:21 AM by user100012345 RSS

    DB Adapter Package call vs Pure SQL call

    DebanjanDe

      Hi ,

       

      We need to call few SQL select statements from BPEL via DB adapter. The SQL may fetch few thousands (1k to 50k possibly) records. We are now analyzing the possible pros and cons in terms of performance of DB Adapter package call vs direct pure SQL call.

      Can you pleas give us any suggestion on it.

       

      Regards,

      Debanjan