Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sync or Async data loading?
Message
From
14/04/2014 07:00:52
 
 
To
14/04/2014 06:33:15
General information
Forum:
ASP.NET
Category:
ADO.NET
Environment versions
Environment:
C# 3.0
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01598573
Message ID:
01598575
Views:
34
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
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform