ExecutorType.BATCH in SQLSessionTemplate - Memory issues

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

ExecutorType.BATCH in SQLSessionTemplate - Memory issues

This post has NOT been accepted by the mailing list yet.

We are using DAO layer with SQLSessionTemplate without any executor (default) .
Currently we have lots of Select statements used heavily.

For inserts and updates the requests/executions are quite less, only for the first time, and data is also of around 5000 inserts.

We are facing memory issues in our application.
Wanted to know does, using a Batch executor makes any sense or help in any manner?
I checked onto documents that Batch executor is used for re usability for inserts and updates, however in our case we are using Selects more.

Kindly let me know.