Click here to Skip to main content
15,181,010 members
Home / Discussions / C#
   

C#

 
QuestionHow to get Millions of files from folder and bulk insert in database Pin
Ankur B. Patel16-Oct-21 2:10
MemberAnkur B. Patel16-Oct-21 2:10 
AnswerRe: How to get Millions of files from folder and bulk insert in database Pin
Eddy Vluggen16-Oct-21 4:10
professionalEddy Vluggen16-Oct-21 4:10 
GeneralRe: How to get Millions of files from folder and bulk insert in database Pin
Richard MacCutchan16-Oct-21 5:00
mveRichard MacCutchan16-Oct-21 5:00 
GeneralRe: How to get Millions of files from folder and bulk insert in database Pin
Eddy Vluggen16-Oct-21 5:18
professionalEddy Vluggen16-Oct-21 5:18 
GeneralRe: How to get Millions of files from folder and bulk insert in database Pin
Ankur B. Patel16-Oct-21 5:59
MemberAnkur B. Patel16-Oct-21 5:59 
GeneralRe: How to get Millions of files from folder and bulk insert in database Pin
Gerry Schmitz16-Oct-21 12:04
mveGerry Schmitz16-Oct-21 12:04 
AnswerRe: How to get Millions of files from folder and bulk insert in database Pin
OriginalGriff16-Oct-21 7:43
mveOriginalGriff16-Oct-21 7:43 
AnswerRe: How to get Millions of files from folder and bulk insert in database Pin
Michael Sydney Balloni16-Oct-21 18:36
mvaMichael Sydney Balloni16-Oct-21 18:36 
Hi Ankur,

I'm going to assume your files are in a bunch of directories, not all in one, or mostly in a few, but leafy. I'd use the System.IO classes Directory and Path and FileInfo. You can use Directory.GetDirectories to get then directories, then loop over those directory paths calling Directory.GetFiles to get file paths to the files, then for each file path call Path.GetFilename to get the filename, and (new FileInfo(filePath)).Length to get the file length. I'd use a DB transaction per directory, and create an INSERT statement per file and execute it inside the transaction, and commit when you're done with the files in that directory.

Things not to do:
Don't get all files in all directories.
Don't build one SQL statement for all the files.

Hope this helps, -Michael

AnswerRe: How to get Millions of files from folder and bulk insert in database Pin
jschell24-Oct-21 7:50
Memberjschell24-Oct-21 7:50 
QuestionPredicateBuilder Question Pin
Kevin Marois15-Oct-21 6:24
professionalKevin Marois15-Oct-21 6:24 
AnswerRe: PredicateBuilder Question Pin
Eddy Vluggen15-Oct-21 15:44
professionalEddy Vluggen15-Oct-21 15:44 
QuestionTask.WhenAll ConfigureAwait Question Pin
Kevin Marois14-Oct-21 13:57
professionalKevin Marois14-Oct-21 13:57 
AnswerRe: Task.WhenAll ConfigureAwait Question Pin
Richard Deeming15-Oct-21 0:15
mveRichard Deeming15-Oct-21 0:15 
GeneralRe: Task.WhenAll ConfigureAwait Question Pin
Kevin Marois15-Oct-21 5:53
professionalKevin Marois15-Oct-21 5:53 
GeneralRe: Task.WhenAll ConfigureAwait Question Pin
Richard Deeming15-Oct-21 6:59
mveRichard Deeming15-Oct-21 6:59 
GeneralRe: Task.WhenAll ConfigureAwait Question Pin
Kevin Marois15-Oct-21 7:29
professionalKevin Marois15-Oct-21 7:29 
GeneralRe: Task.WhenAll ConfigureAwait Question Pin
Kevin Marois15-Oct-21 9:08
professionalKevin Marois15-Oct-21 9:08 
GeneralRe: Task.WhenAll ConfigureAwait Question Pin
Richard Deeming17-Oct-21 22:58
mveRichard Deeming17-Oct-21 22:58 
GeneralRe: Task.WhenAll ConfigureAwait Question Pin
Kevin Marois18-Oct-21 5:01
professionalKevin Marois18-Oct-21 5:01 
QuestionCodility fails to compile even though it compiles in VS code? Pin
Cliff ludo13-Oct-21 7:41
MemberCliff ludo13-Oct-21 7:41 
AnswerRe: Codility fails to compile even though it compiles in VS code? Pin
BillWoodruff13-Oct-21 18:11
mveBillWoodruff13-Oct-21 18:11 
Generalpass array to function Pin
Cliff ludo13-Oct-21 0:04
MemberCliff ludo13-Oct-21 0:04 
GeneralRe: pass array to function Pin
Richard Deeming13-Oct-21 0:25
mveRichard Deeming13-Oct-21 0:25 
GeneralRe: pass array to function Pin
Cliff ludo13-Oct-21 0:32
MemberCliff ludo13-Oct-21 0:32 
QuestionCreating An Async Method Pin
Kevin Marois7-Oct-21 12:02
professionalKevin Marois7-Oct-21 12:02 

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.