Consult everybody a great god a question, I take the all data projected in PreparedStatement, then once submitted, the source code is shown in figure 3, with km not outside the network, please everyone will see, figure a batch update data for a business, speed is faster, figure 2. Another business batch update data, both SQL statement is the same, also use the same tools (figure 3), please help to analysis why there are so much difference, thank you,

CodePudding user response:

This conflict with the lock, the execution plan, indexes have used, for example, if two business on a different server, the server performance also have relations

CodePudding user response:

Two business are on the same server, both business is actually I write test, were separately performed a separately and perform another, should there is no conflict,

CodePudding user response:

Two business is corresponding to the same table?

Consistent, SQL execution plan?

CodePudding user response:

The

reference 3 floor by the stars of a cold reply:

two business is corresponding to the same table?

Consistent, SQL execution plan?

the same table, consistent execution plan is what mean? I use the same tools,

CodePudding user response:

Of SQL execution plan, but it should not be the problem, the best screening,

Two business logic is what? Maybe there are different among both waiting or process?