Batch inserts/updates/deletes and BatchResults

[Matt Passell]

Hi All,

I've read through the user guide, past discussions in the group, and the MyBatis source, and I think I understand how I'd use a BatchExecutor to execute a batch and get back BatchResults for the executed statements, but I wanted to confirm that I'm on the right track.  Does code like the following (ignoring error handling for the moment) look reasonable?

    SqlSession session = ssFactory.openSession(ExecutorType.BATCH);

    GroupMapper mapper = session.getMapper(GroupMapper.class);

    

    for (Group group : groups) {

      mapper.addGroup(group);

    }

    

    List<BatchResult> results = session.flushStatements();

    session.commit();

    session.close();

Thanks,

Matt

[Eduardo]

100% Matt. That is the right way to get the results.

[KEN]

I have test, the test report show that: Comparing with ibatis,
mybatis's batch insert operation cost double time. It is close to
hibernate performance.

[Eduardo Macarron]

Hi, Matt is referring to Spring-Batch, not to MyBatis-Batch.

This information is valued. Have you done a profiling? do you have any
idea of where the time is lost?

If you don't mind, please open a new thread to follow this conversation.

[KEN]

Sorry, I am discussing in another thread, I attach the code and test
data, any advice is welcome.

topic: Mybatis is very much slower than Ibatis or Jdbc
url: http://groups.google.com/group/mybatis-user/browse_thread/thread/58ce58e1d708cac6

[Eduardo Macarron]

El día 12 de abril de 2012 09:27, Eduardo Macarron
<eduardo....@gmail.com> escribió:

> Hi, Matt is referring to Spring-Batch, not to MyBatis-Batch.

Sorry for the mess. It is Prashant who asked about Spring Batch, not Matt :)

[Matt Passell]

Hi Eduardo,

Thanks!  It appears to be working fine. :)

Thanks,

Matt

[Matt Passell]

Thanks for clarifying that.  I was about to send an email saying, "Hmm. I thought I was talking about MyBatis-Batch..." ;)

--Matt