Last post Jun 14, 2017 06:09 AM by Eric Du
Jun 13, 2017 03:54 PM|maheshvishnu|LINK
I a trying to insert excel data(200 thousand rows)records into database. i followed below article which is working for 100-150 rows only, why is it not able to handle 200K rows? It is taking lot of time for 200k rows but no exception thrown
Any limitiations with array size?
Jun 14, 2017 06:09 AM|Eric Du|LINK
According to your description and sample code, I know use this method to read data, the meaning is read all data and store in memory, because the data is huge, it is possible that make data crash in the memory.
So my suggestion is you could try divide one into multiple times to read and store your data. Like at first time, read the 10% data and save them in database, then read the data from 11%-20%, then save them in database at the second time. .....
This will reduce memory consumption.