java - Hibernate : dynamic-update dynamic-insert - Performance Effects -

Dynamic-update or dynamic-insert use is positive, though usually only on display, as

But the reference documentation mentions that there may be negative display effects as follows:

Although these settings can increase performance in some cases, they are actually in others Can reduce performance. / P>

Can anyone suggest some examples / scenarios on which negative display effect is mentioned?

for each entity, the actual INSERT / SELECT / UPDATE caches the hibernate to SQL strings and The obvious advantage is that there is no need to calculate SQL, when you continue, find or update a unit.

However, when using dynamic-insert or dynamic-updates, hibernate is to generate this same SQL string each time and thus there is a display cost on the hibernate side.

In another, there is a trade-off between word, database side and overhead on the hibernate side.

My point is that dynamic insertion and dynamic updates can be interesting for tables with a thick blanket column or tables, in other cases with large numbers of columns, I am not sure whether the dynamic entry Or update always means performance boost (I do not use them by default) < / Li> >