Hello every body,
I working an application in C# to process a log file that has a size 1 terabytes.
I have to read the file row by row and insert each row in the DataBase to search in it, and I use a stored procedure.
But I have a problem in transaction of query to SQL DataBase because it takes a lot of time and the computer be in "not responsible" mode because of the huge number of rows in the file.
How can i reduce the time which the query takes to be executed and optimize the performance.
alaad
0
Newbie Poster
Recommended Answers
Jump to PostNo-one can know until they see how you do it now
Jump to PostThere are SQL statements which differ in the way they are written but faster when it comes in loading data.
You should also consider some factors:
Network speed (if it is networked) Transmission line capacity (still, if networked)
All 6 Replies
Suzie999
245
Coding Hobbyist
abelingaw
69
Posting Whiz in Training
Mike Askew
131
Veteran Poster
Featured Poster
alaad
0
Newbie Poster
Mike Askew
131
Veteran Poster
Featured Poster
Suzie999
245
Coding Hobbyist
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.