| CranCran77 2005-11-11, 7:48 am |
| Hello everyone -
I am using an ODBC adapter to connect BizTalk to my Oracle database. I
have a few very complex orchestrations which must extract data from
7-10 different tables in my Oracle database and transmitted as an IDOC
to the customer using an SAP adapter.
It seems as though when I call a 'send port' to query the database for
information, it takes much longer to extract the information than if I
were in my sql client tool and run the query. From the client takes <
1 sec but in BizTalk it appears to take 3-5 seconds.
Is this because each Send Port call much 1) create a connection and
establish the connection, 2) execute the data query, 3) close the
connection, and 4) maintain persistence data in SQL server?
Is there anyway I can avoid this and make this process much more
streamlined. This is going to kill me having thousands of documents
which must be transmitted in order from Oracle to SAP and being complex
IDOCs to have this kind of time footprint to create a single document.
Thanks
Chris
|