For help: a performace issue of mybatis 3.5.3

43 views
Skip to first unread message

gsbb2004

unread,
May 14, 2022, 10:17:47 PM5/14/22
to mybatis-user
My team meet a performance issue of mybatis 3.5.3, execute a simple select from mysql which takes about 15 seconds. The result of this query is a List<Map>, and the count of the list is 150. The mapper is as follow:

<select id = 'selectMapList' reusltMap='mainMap'>
      select #90 properties# from table where #condition#
</select>

<resultMap id = 'mainMap' type='java.util.Map'>
      #90 <result> label #
</resultMap>

But when I update the version to 3.5.4, it works fine. I have traced the source code and found DefaultResultSetHandler#handleRowValuesForSimpleResultMap method cost too much time, but I can't found the root cause of this scenario. Could somebody help me about this? thx.

Iwao AVE!

unread,
May 17, 2022, 7:38:01 PM5/17/22
to mybatis-user
Hello,

The community improves MyBatis continuously, so it is no mystery if the newer version works faster.
If your goal is to improve the performance, just use the newer version.
We always recommend the latest version (3.5.9 at the moment).

If it's a "I'm just curious" question, you should use `git bisect` to find the exact commit that affects the performance.
Notable changes are listed in the release note.
Without concrete information, there is not much other developers can do about performance issues.

Regards,
Iwao

--
You received this message because you are subscribed to the Google Groups "mybatis-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mybatis-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mybatis-user/81aa5b3c-6ac7-4771-af18-9581bc802743n%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages