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...