BizTalk, Functoids, Performance

Caching database functoid and throttling

In case you haven’t seen the Blogical.Shared.Functoids.ExecuteQuery, and the feature post at Mikael Håkanssons blog, it’s a cache enabled database lookup functoid – a revised version of a functoid that we have successfully used on previous projects, available for download on codeplex. Caching can greatly increase the performance of any solution. However BizTalk caching, as with all caching, has to be done wisely and with moderation. So be sure to test (and monitor) thoroughly for memory saturation so that you don’t hit throttling limits effectively bringing your BizTalk solution to a stand still. A good read that exemplifies the latter is this recent post by Yossi Dahan. Keep it in mind when using the functoid.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s