BizTalk Server General - OPtimizing SQL

Author

OPtimizing SQL

maverick

2004-12-08, 7:18 pm

We are using functoids for mapping. These functoids are pulling iformation from Oracle. Now, there are 30 of these functoids. That means the database connection is opened and closed 30 times for each map. How can be optimize these 30 SQL queries so that the database connection is opened only once.

1)Is there anything to do wid stored procedures? If yes, then please i want more specifics....

2) Can we pull all data from database using something and then close the connection and then use that something for all data needs? What can be that something and how to do that?

Thanks