BizTalk Database Lookup Functoids
I've been working on a BizTalk 2006 solution that utilises the Database Lookup Functoids in the BizTalk Mapper.
I use the Database Lookup functoid to define the connection etc. And then I use the Value Extractor about 10 times to get the individual values out of a view.
It wasn't working as I expected though, so I fired up SQL Profiler to have a ganders and was shocked at what I saw.
I saw about 10 hits to the database running a SELECT * FROM [myview] for each functoid!
Instead of doing a single select with the Database Lookup (as one would expect), it repeated the same query for each value extracted!
If I had written the same thing into my code manually, a DBA would have probably battered me into the ground. I'm wondering how long it'll go before somebody notices...