Click here to Skip to main content
11,706,455 members (46,389 online)
Rate this: bad
Please Sign up or sign in to vote.
Im trying to process data from my sql server in a chronological manner. The data is too large to fit into memory all at once so i have written a SProc which uses paging and returns X number of records.

To speed up the processing, i create a collection of X number of tasks and assign them different inputs. Each task is assigned different inputs, and they begin read/processing the datatable.

The following is where im stuck:

1)I need a way of pausing each task once it has finished reading all the data from the datatable.

2)Waiting until all the other tasks in the collection have finished reading the datatable.

3)Calling my SProc in order to load the next page of data into the datatable.

4)Recommence the tasks such that their local variable havent changed. ( i was planning to keep the results of each task in a local variable but if this isnt ideal im open to suggestions)
Posted 12-Nov-12 3:36am

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 197
1 Sergey Alexandrovich Kryukov 141
2 chainerlt 110
3 ppolymorphe 71
4 Mika Wendelius 70
0 OriginalGriff 9,070
1 Sergey Alexandrovich Kryukov 8,413
2 CPallini 5,189
3 Maciej Los 4,746
4 Mika Wendelius 3,676

Advertise | Privacy | Mobile
Web01 | 2.8.150819.1 | Last Updated 12 Nov 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100