Before considering async all its issues, look at doing more in SQL Server. Last year I inherited an app that was taking hours to run. Once I optimized the queries and offloaded much of the processing to stored procs, it now runs in just a few minutes.

>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