Execute to Parse ratio

17 views

Skip to first unread message

Vijay Maske

unread,

Mar 4, 2021, 7:59:37 AM3/4/21

to mybatis-user

HI,

We found that there are almost one to one count of number of executions and number os parses for sqls. All our SQLs have dynamic variables like #{parameter}.

DBA team has asked to check application logic. Can anyone help me to in this case. What to be checked in application logic.

Regards,

Vijay Maske

Guy Rouillier

unread,

Mar 4, 2021, 4:25:58 PM3/4/21

to MyBatis User

In the MyBatis User Guide, take a look at defaultExecutorType. The default value is SIMPLE, which does nothing. To reuse prepared statements, you'll want to specify defaultExecutorType REUSE.

Guy Rouillier

--
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/8464dbd0-3057-478a-a6ce-4c684d40f401n%40googlegroups.com.

Reply all

Reply to author

Forward

0 new messages