Hi all, I am executing an rs.executeBatch() which has 200000 statements in it... During execution it throws java.lang.OutOfMemory Exception.
How can i avoid this...
posted 11 years ago
One way is to increase the heap memory. But trying to batch 200000 queries at one go, looks too much. Probably you should consider splitting up into smaller sizes. For example, the following code snippet will batch upto 100 queries at a time.