开发者

WCF: Efficiently consuming large numbers of singleton requests via SQL job?

开发者 https://www.devze.com 2022-12-16 00:32 出处:网络
I\'m p开发者_如何学编程lanning to build a console app to run as part of a SQL 2005 job which will gather records from a database table, create a request object for a WCF service, pass this object to t

I'm p开发者_如何学编程lanning to build a console app to run as part of a SQL 2005 job which will gather records from a database table, create a request object for a WCF service, pass this object to the service for processing, receive a response object, and update a log table with its data. This will be for processing at least several thousand records each time the job step executes.

The WCF service currently exposes a single method which I'd be hitting once for each record in the table, so I imagine I'd want to open a channel to the service, keep it open during processing, then close and dispose and such when complete.

Beyond maintaining the connection, how else could I minimize this console app's performance as a bottleneck? Should I not use a console app and instead try using SQLCLR or some other means to perform this processing?


You've probably considered Service Broker...

0

精彩评论

暂无评论...
验证码 换一张
取 消