Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > Biztalk
|
Biztalk General discussion about Biztalk server.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Biztalk section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 20th, 2005, 07:41 AM
Registered User
 
Join Date: Mar 2005
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default Error handling with performance improvement

Need some help with error handling. I'm using SQL adapter to insert records into the database. I read these records from a flat file. For my send port sending these records to be inserted in the database, I have set the Delivery Notification property = Transmitted. If any error such as primary key voilation or invalid data format occurs then they are caught using the DeliveryNotificationException. This is done exactly the same way as shown by Stephen Thomas's Sample given at
http://www.geekswithblogs.com/sthoma...1/01/9234.aspx
But doing it this way gives performance issues. It degrades the perforamance a lot. So much that to insert about 13000 records after reading it from my flat file into the database takes about 5 days. Is there any way around that these SQL errors could be caught and reported with better performance or is it that to report error from SQL only DeliveryNotificationException has to be used?
Any help in this regard would be appreciated.

Thanks a lot.





Similar Threads
Thread Thread Starter Forum Replies Last Post
error handling prv299 .NET Web Services 5 May 19th, 2008 07:27 AM
Error Handling harpua Beginning PHP 0 October 28th, 2006 12:05 PM
error handling Abhinav_jain_mca General .NET 5 December 21st, 2005 01:12 AM
Dynamic Dependent List Box improvement SoC Classic ASP Basics 1 August 16th, 2004 01:02 AM
Error Handling zaeem Classic ASP Basics 2 November 14th, 2003 10:42 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.