Click here to Skip to main content
15,123,757 members
Home / Discussions / C#
   

C#

 
QuestionParse 17,000 text files and insert into database Pin
davers15-Nov-16 7:29
Memberdavers15-Nov-16 7:29 
AnswerRe: Parse 17,000 text files and insert into database Pin
TX643015-Nov-16 8:01
MemberTX643015-Nov-16 8:01 
AnswerRe: Parse 17,000 text files and insert into database Pin
Gerry Schmitz15-Nov-16 8:13
mveGerry Schmitz15-Nov-16 8:13 
GeneralRe: Parse 17,000 text files and insert into database Pin
davers15-Nov-16 9:07
Memberdavers15-Nov-16 9:07 
GeneralRe: Parse 17,000 text files and insert into database Pin
OriginalGriff15-Nov-16 9:17
mveOriginalGriff15-Nov-16 9:17 
GeneralRe: Parse 17,000 text files and insert into database Pin
Gerry Schmitz15-Nov-16 9:19
mveGerry Schmitz15-Nov-16 9:19 
GeneralRe: Parse 17,000 text files and insert into database Pin
TX643015-Nov-16 9:50
MemberTX643015-Nov-16 9:50 
AnswerRe: Parse 17,000 text files and insert into database Pin
Philippe Mori15-Nov-16 9:11
MemberPhilippe Mori15-Nov-16 9:11 
  • Your code is prone to SQL injection (if the source file can be modified).
  • You might want to process files in order.
  • Your code do not validate that the data is the expected one.
  • There are a bunch of hard-coded constant.
If you do it one, then it does not matters much but it would also do not matters much that it would take about one hour to process the file.

One thing that would have a significant impact on the performance is to keep the connection opened for the whole importation if it is not already done.
Philippe Mori

AnswerRe: Parse 17,000 text files and insert into database Pin
Nathan Minier15-Nov-16 9:33
professionalNathan Minier15-Nov-16 9:33 
AnswerRe: Parse 17,000 text files and insert into database Pin
Mycroft Holmes15-Nov-16 12:54
professionalMycroft Holmes15-Nov-16 12:54 
AnswerRe: Parse 17,000 text files and insert into database Pin
Bernhard Hiller15-Nov-16 22:33
MemberBernhard Hiller15-Nov-16 22:33 
AnswerRe: Parse 17,000 text files and insert into database Pin
Jimmanuel23-Nov-16 11:48
MemberJimmanuel23-Nov-16 11:48 
QuestionDevelop Web Service REST Pin
Member 1283622014-Nov-16 4:37
MemberMember 1283622014-Nov-16 4:37 
QuestionTextbox updation Pin
Avinash.Banda14-Nov-16 1:24
MemberAvinash.Banda14-Nov-16 1:24 
AnswerRe: Textbox updation Pin
OriginalGriff14-Nov-16 1:31
mveOriginalGriff14-Nov-16 1:31 
GeneralRe: Textbox updation Pin
Avinash.Banda14-Nov-16 1:36
MemberAvinash.Banda14-Nov-16 1:36 
GeneralRe: Textbox updation Pin
OriginalGriff14-Nov-16 1:39
mveOriginalGriff14-Nov-16 1:39 
GeneralRe: Textbox updation Pin
Avinash.Banda14-Nov-16 1:43
MemberAvinash.Banda14-Nov-16 1:43 
GeneralRe: Textbox updation Pin
OriginalGriff14-Nov-16 1:45
mveOriginalGriff14-Nov-16 1:45 
GeneralRe: Textbox updation Pin
Avinash.Banda14-Nov-16 1:52
MemberAvinash.Banda14-Nov-16 1:52 
GeneralRe: Textbox updation Pin
OriginalGriff14-Nov-16 2:03
mveOriginalGriff14-Nov-16 2:03 
GeneralRe: Textbox updation Pin
Avinash.Banda14-Nov-16 2:04
MemberAvinash.Banda14-Nov-16 2:04 
QuestionCan I send Push Notifications to mobile phones from Windows Forms Application? Pin
Onur ERYILMAZ14-Nov-16 0:58
MemberOnur ERYILMAZ14-Nov-16 0:58 
AnswerRe: Can I send Push Notifications to mobile phones from Windows Forms Application? Pin
Eddy Vluggen14-Nov-16 4:51
professionalEddy Vluggen14-Nov-16 4:51 
QuestionFile Transfer Queue Architecture Pin
Kevin Marois10-Nov-16 7:16
professionalKevin Marois10-Nov-16 7: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.