>Hi
>I am develop class to do long running processing.
>In my processing logic, the 1st thing to do would be retrieve all corresponding data and reference data from server to my middle tier, then loop them and etc.
>
>I would like to seek for your opinion, should I load these data in sync mode or async mode? Would async mode has better performance?
>How could I improve performance of data loading perspective?
>
>thank you
Don't think there is a simple answer. This might help :
http://blogs.msdn.com/b/adonet/archive/2012/04/20/using-sqldatareader-s-new-async-methods-in-net-4-5-beta.aspx