0



I am currently trying to implement solution for data intensive tasks . For responsiveness i reverted to Async model for EF. Which however, does leave UI Responsive. But, for some reason every consecutive 1000 entries gets slower and slower at some rate. e.g. it took 120 sec ( rounding Up ) to process 1000 Entries. Next 1000 took 240 Sec() and so on......
Details of op.

1. Getting List of entries from a table ( with 21000 ) entries.
2. Creating In Memory New Objects from each entry retrieved . ( Note: Not committing to EF. Just in memory).
3. Save these entries to DB.

DB is SQLExpress 2014 local server.

I figure that the lag is due to entries being fetched by EF. I have tried Both LINQ and standard EF approach e.g. MyObjectContext.MyEntities.ToList.
So, can somebody help me guide in right direction. What is the best way to process bulk data operations while still keeping performance intact. Thanks

Jas Sra
  • 3
  • 1
  • 4
  • 1
    possible duplicate of [Improving bulk insert performance in Entity framework](http://stackoverflow.com/questions/6107206/improving-bulk-insert-performance-in-entity-framework) – crthompson Jun 23 '14 at 04:02
  • you could try loading pages of data... or maybe even in combination with recreation of the context. – Learner Jun 25 '14 at 12:48

0 Answers0