Ankur Patel

Ankur Patel

  • 0
  • 16
  • 0

how to Get Millions of files from folder and bulk insert in database ?

Oct 16 2021 11:25 AM

I have some folders having files, its count like 40Lac, 70Lac, 1Cr, 1.5cr... and filetype like .png, .xlsx, .txt, .msg, .ico, .jpg, .bmp etc...

Now I want to insert this filename into my database table with its size... but when I implement it takes too much time to scan the folder and then after it throws a memory exception.

can anyone please help me out here, how can I implement this scenario in a better manner?
how can insert faster in the table?

I am using C#.net with the PostgreSQL database...


Answers (3)