Click here to Skip to main content
15,896,154 members
Home / Discussions / C#
   

C#

 
AnswerRe: Encode two integers Pin
Heath Stewart16-Oct-05 0:17
protectorHeath Stewart16-Oct-05 0:17 
GeneralRe: Encode two integers Pin
JoaoPe16-Oct-05 2:33
JoaoPe16-Oct-05 2:33 
AnswerRe: Encode two integers Pin
Heath Stewart16-Oct-05 17:14
protectorHeath Stewart16-Oct-05 17:14 
QuestionWinService issues Pin
WetRivrRat15-Oct-05 13:42
WetRivrRat15-Oct-05 13:42 
AnswerRe: WinService issues Pin
Heath Stewart16-Oct-05 0:25
protectorHeath Stewart16-Oct-05 0:25 
QuestionRead until "- -" ??? Pin
WetRivrRat15-Oct-05 13:06
WetRivrRat15-Oct-05 13:06 
AnswerRe: Read until "- -" ??? Pin
Robert Rohde15-Oct-05 22:29
Robert Rohde15-Oct-05 22:29 
AnswerRe: Read until "- -" ??? Pin
Scott Serl16-Oct-05 15:00
Scott Serl16-Oct-05 15:00 
I wouldn't worry if you mean 100+KB per day, because that is quite small. If you mean 100+K records, then it could take a while. Just read each line, split it with split('- -'), and shove it into the database using a stored procedure. On a moderate single processor machine running sql server, you should easily get 1000 records per second. A very slow server may take up to 5 times longer.
Try the simple approach first, then optimize later. If you DO need to optimize, look to sending batches of inserts in each command, or passing your data as strings into a stored proc and parsing them out in there. Usually, these extremes are not necessary.

Simple approach:
StreamReader sr;
String str;
String[] arr;
String delim = "- -";
SQLCommand cmd;
SQLConnection cn;

//init connetion and command here and open connection
//open streamreader here

str = sr.ReadLine;
while (sr.Peek() >= 0)
{
arr = str.Split(delim.ToCharArray());
cmd.Parameters("@Param1").Value = arr[0];
...

cmd.ExecuteNonQuery();
}

cn.close;
sr.close;

Questionvideo streaming, Is it possible Pin
serguey_haftrige15-Oct-05 12:23
serguey_haftrige15-Oct-05 12:23 
AnswerRe: video streaming, Is it possible Pin
leppie15-Oct-05 23:24
leppie15-Oct-05 23:24 
QuestionPersistence Pin
Sled Dog15-Oct-05 11:27
Sled Dog15-Oct-05 11:27 
AnswerRe: Persistence Pin
Rob Philpott16-Oct-05 1:14
Rob Philpott16-Oct-05 1:14 
GeneralRe: Persistence Pin
Sled Dog16-Oct-05 3:54
Sled Dog16-Oct-05 3:54 
GeneralRe: Persistence Pin
Rob Philpott16-Oct-05 4:19
Rob Philpott16-Oct-05 4:19 
GeneralRe: Persistence Pin
Sled Dog16-Oct-05 4:37
Sled Dog16-Oct-05 4:37 
GeneralRe: Persistence Pin
Rob Philpott16-Oct-05 4:54
Rob Philpott16-Oct-05 4:54 
Question"Public Shared" equivalent in VB & Global Pin
Sled Dog15-Oct-05 9:52
Sled Dog15-Oct-05 9:52 
AnswerRe: "Public Shared" equivalent in VB & Global Pin
Sled Dog15-Oct-05 9:59
Sled Dog15-Oct-05 9:59 
AnswerRe: "Public Shared" equivalent in VB & Global Pin
Sled Dog15-Oct-05 11:08
Sled Dog15-Oct-05 11:08 
QuestionDetermining DNS servers with C# Pin
Rob Philpott15-Oct-05 7:45
Rob Philpott15-Oct-05 7:45 
AnswerRe: Determining DNS servers with C# Pin
leppie15-Oct-05 21:24
leppie15-Oct-05 21:24 
GeneralRe: Determining DNS servers with C# Pin
Rob Philpott15-Oct-05 23:54
Rob Philpott15-Oct-05 23:54 
QuestionStill locked in first TextBox Pin
Anonymous15-Oct-05 6:16
Anonymous15-Oct-05 6:16 
JokeRe: Still locked in first TextBox Pin
leppie15-Oct-05 7:10
leppie15-Oct-05 7:10 
GeneralRe: Still locked in first TextBox Pin
Anonymous15-Oct-05 9:16
Anonymous15-Oct-05 9:16 

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.