Click here to Skip to main content
16,007,163 members
Home / Discussions / C#
   

C#

 
AnswerRe: start the application at computer start Pin
musefan2-Feb-09 1:13
musefan2-Feb-09 1:13 
AnswerRe: start the application at computer start Pin
Spunky Coder2-Feb-09 1:19
Spunky Coder2-Feb-09 1:19 
GeneralRe: start the application at computer start Pin
MadArtSoft2-Feb-09 1:51
MadArtSoft2-Feb-09 1:51 
Questionreading huge set of data from Db Pin
prasadbuddhika2-Feb-09 0:58
prasadbuddhika2-Feb-09 0:58 
AnswerRe: reading huge set of data from Db Pin
musefan2-Feb-09 1:11
musefan2-Feb-09 1:11 
GeneralRe: reading huge set of data from Db Pin
prasadbuddhika2-Feb-09 2:35
prasadbuddhika2-Feb-09 2:35 
GeneralRe: reading huge set of data from Db Pin
PIEBALDconsult2-Feb-09 4:26
mvePIEBALDconsult2-Feb-09 4:26 
AnswerRe: reading huge set of data from Db Pin
Wendelius2-Feb-09 5:16
mentorWendelius2-Feb-09 5:16 
prasadbuddhika wrote:
i want to read huge no of records(100000) from the db using one connection. i want to do this using threads, how can i get the data in parallel


In order to do this, you must use multiple connections, one for each simultaneous access.

prasadbuddhika wrote:
problem is how to tell one thread to get specified range of data


Use BackgroundWorker and RunWorkerAsync method. Create a simple class which holds the data for you (range start and amount of data) and pass that to the RunWorkerAsync method.

Warning, it's very likely that this will be slower than fetching all at once. Especially if you're going to use the amount of records as the range (instead of for example primary key values), the throughput will be catastrophic.

The need to optimize rises from a bad design.My articles[^]

GeneralRe: reading huge set of data from Db Pin
prasadbuddhika2-Feb-09 18:55
prasadbuddhika2-Feb-09 18:55 
GeneralRe: reading huge set of data from Db Pin
PIEBALDconsult3-Feb-09 4:34
mvePIEBALDconsult3-Feb-09 4:34 
GeneralRe: reading huge set of data from Db Pin
Wendelius3-Feb-09 7:05
mentorWendelius3-Feb-09 7:05 
Questioninput fro array list Pin
lawrenceinba2-Feb-09 0:19
lawrenceinba2-Feb-09 0:19 
AnswerRe: input fro array list Pin
S a n d y2-Feb-09 0:37
S a n d y2-Feb-09 0:37 
QuestionParse wbXML, N95 Pin
MANOJ BATRA1-Feb-09 23:48
MANOJ BATRA1-Feb-09 23:48 
AnswerRe: Parse wbXML, N95 Pin
Spunky Coder2-Feb-09 0:26
Spunky Coder2-Feb-09 0:26 
QuestionFinding the Spelling mistake in rich text box in c#.net Pin
Lijo Rajan1-Feb-09 23:33
Lijo Rajan1-Feb-09 23:33 
AnswerRe: Finding the Spelling mistake in rich text box in c#.net Pin
musefan1-Feb-09 23:57
musefan1-Feb-09 23:57 
GeneralRe: Finding the Spelling mistake in rich text box in c#.net Pin
Lijo Rajan2-Feb-09 0:00
Lijo Rajan2-Feb-09 0:00 
GeneralRe: Finding the Spelling mistake in rich text box in c#.net Pin
musefan2-Feb-09 0:03
musefan2-Feb-09 0:03 
GeneralRe: Finding the Spelling mistake in rich text box in c#.net Pin
Lijo Rajan2-Feb-09 0:04
Lijo Rajan2-Feb-09 0:04 
GeneralRe: Finding the Spelling mistake in rich text box in c#.net Pin
musefan2-Feb-09 1:41
musefan2-Feb-09 1:41 
GeneralRe: Finding the Spelling mistake in rich text box in c#.net Pin
Christian Graus2-Feb-09 0:13
protectorChristian Graus2-Feb-09 0:13 
AnswerRe: Finding the Spelling mistake in rich text box in c#.net Pin
Giorgi Dalakishvili2-Feb-09 1:17
mentorGiorgi Dalakishvili2-Feb-09 1:17 
Questionextract domain from URL Pin
Eli Nurman1-Feb-09 22:57
Eli Nurman1-Feb-09 22:57 
AnswerRe: extract domain from URL Pin
musefan1-Feb-09 23:13
musefan1-Feb-09 23:13 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.