I am processing very big files.. I get out of memory exception when I process every 1000 records in the file.. but processing 100 records is okay. but procesing every 100 records is using longer time than processing every 10 records.. I get two questions here.
1. how can I know the memory will be used out and can do some detection before it throw me an exception?
2. Why my processing every 10 record at a time is faster? how can I get the best performance..