ode-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rafal Rusin (JIRA)" <j...@apache.org>
Subject [jira] Updated: (ODE-640) Reduce inserts to LARGE_DATA in dao-hib
Date Tue, 28 Jul 2009 18:18:14 GMT

     [ https://issues.apache.org/jira/browse/ODE-640?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Rafal Rusin updated ODE-640:
----------------------------

    Attachment: opt-test.diff

To diagnose it, apply this patch and run
buildr _1.2.10_ test:HelloWorldJbiTest
Then look up inserts in test.log

> Reduce inserts to LARGE_DATA in dao-hib
> ---------------------------------------
>
>                 Key: ODE-640
>                 URL: https://issues.apache.org/jira/browse/ODE-640
>             Project: ODE
>          Issue Type: Improvement
>          Components: BPEL Runtime
>    Affects Versions: 1.3.2, 2.0
>            Reporter: Rafal Rusin
>            Assignee: Rafal Rusin
>             Fix For: 1.3.3, 2.0
>
>         Attachments: opt-test.diff
>
>
> Each time assign:copy is executed in one transaction (job), there's an insert to LARGE_DATA.
The goal is to have only one insert for one variable update. 
> Here are details for 20 copy operation on the same variable:
> for ODE-1.X:
>  07-28@15:31:45 DEBUG (GeronimoLog.java:66)     -  Insert 0: insert into LARGE_DATA (BIN_DATA,
INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:49 DEBUG (GeronimoLog.java:66)     - Beginning a new transaction
>  07-28@15:31:49 DEBUG (GeronimoLog.java:66)     - Commiting on org.apache.geronimo.transaction.manager.GeronimoTransactionManager@10b755d...
>  07-28@15:31:49 DEBUG (GeronimoLog.java:66)     - Beginning a new transaction
>  07-28@15:31:49 DEBUG (GeronimoLog.java:66)     - Commiting on org.apache.geronimo.transaction.manager.GeronimoTransactionManager@10b755d...
>  07-28@15:31:51 DEBUG (GeronimoLog.java:66)     - Beginning a new transaction
>  07-28@15:31:51 DEBUG (GeronimoLog.java:66)     - Commiting on org.apache.geronimo.transaction.manager.GeronimoTransactionManager@10b755d...
>  07-28@15:31:51 DEBUG (GeronimoLog.java:66)     - Commiting ODE MEX {MyRoleMex#65536
[Client ID:127.0.1.1-122c18fcd42-3:0] calling {urn:/HelloWorld2.wsdl}HelloService.Hello(...)}
>  07-28@15:31:51 DEBUG (GeronimoLog.java:66)     - insert into LARGE_DATA (BIN_DATA, INSERT_TIME,
MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:51 DEBUG (GeronimoLog.java:66)     - prepareStatement: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:52 DEBUG (GeronimoLog.java:66)     - Beginning a new transaction
>  07-28@15:31:53 DEBUG (GeronimoLog.java:66)     - insert into LARGE_DATA (BIN_DATA, INSERT_TIME,
MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:53 DEBUG (GeronimoLog.java:66)     - prepareStatement: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:53 DEBUG (GeronimoLog.java:66)     - insert into LARGE_DATA (BIN_DATA, INSERT_TIME,
MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:53 DEBUG (GeronimoLog.java:66)     - prepareStatement: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:53 DEBUG (GeronimoLog.java:66)     - insert into LARGE_DATA (BIN_DATA, INSERT_TIME,
MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:53 DEBUG (GeronimoLog.java:66)     - prepareStatement: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:53 DEBUG (GeronimoLog.java:66)     - insert into LARGE_DATA (BIN_DATA, INSERT_TIME,
MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:53 DEBUG (GeronimoLog.java:66)     - prepareStatement: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:54 DEBUG (GeronimoLog.java:66)     - insert into LARGE_DATA (BIN_DATA, INSERT_TIME,
MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:54 DEBUG (GeronimoLog.java:66)     - prepareStatement: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:54 DEBUG (GeronimoLog.java:66)     - insert into LARGE_DATA (BIN_DATA, INSERT_TIME,
MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:54 DEBUG (GeronimoLog.java:66)     - prepareStatement: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:54 DEBUG (GeronimoLog.java:66)     - insert into LARGE_DATA (BIN_DATA, INSERT_TIME,
MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:54 DEBUG (GeronimoLog.java:66)     - prepareStatement: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:54 DEBUG (GeronimoLog.java:66)     - insert into LARGE_DATA (BIN_DATA, INSERT_TIME,
MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:54 DEBUG (GeronimoLog.java:66)     - prepareStatement: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:54 DEBUG (GeronimoLog.java:66)     - insert into LARGE_DATA (BIN_DATA, INSERT_TIME,
MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:54 DEBUG (GeronimoLog.java:66)     - prepareStatement: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:54 DEBUG (GeronimoLog.java:66)     - insert into LARGE_DATA (BIN_DATA, INSERT_TIME,
MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:54 DEBUG (GeronimoLog.java:66)     - prepareStatement: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:54 DEBUG (GeronimoLog.java:66)     - insert into LARGE_DATA (BIN_DATA, INSERT_TIME,
MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:54 DEBUG (GeronimoLog.java:66)     - prepareStatement: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:54 DEBUG (GeronimoLog.java:66)     - insert into LARGE_DATA (BIN_DATA, INSERT_TIME,
MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:54 DEBUG (GeronimoLog.java:66)     - prepareStatement: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:55 DEBUG (GeronimoLog.java:66)     - insert into LARGE_DATA (BIN_DATA, INSERT_TIME,
MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:55 DEBUG (GeronimoLog.java:66)     - prepareStatement: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:55 DEBUG (GeronimoLog.java:66)     - insert into LARGE_DATA (BIN_DATA, INSERT_TIME,
MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:55 DEBUG (GeronimoLog.java:66)     - prepareStatement: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:55 DEBUG (GeronimoLog.java:66)     - insert into LARGE_DATA (BIN_DATA, INSERT_TIME,
MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:55 DEBUG (GeronimoLog.java:66)     - prepareStatement: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:55 DEBUG (GeronimoLog.java:66)     - insert into LARGE_DATA (BIN_DATA, INSERT_TIME,
MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:55 DEBUG (GeronimoLog.java:66)     - prepareStatement: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:55 DEBUG (GeronimoLog.java:66)     - insert into LARGE_DATA (BIN_DATA, INSERT_TIME,
MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:55 DEBUG (GeronimoLog.java:66)     - prepareStatement: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:55 DEBUG (GeronimoLog.java:66)     - insert into LARGE_DATA (BIN_DATA, INSERT_TIME,
MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:55 DEBUG (GeronimoLog.java:66)     - prepareStatement: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:55 DEBUG (GeronimoLog.java:66)     - insert into LARGE_DATA (BIN_DATA, INSERT_TIME,
MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:55 DEBUG (GeronimoLog.java:66)     - prepareStatement: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:55 DEBUG (GeronimoLog.java:66)     - insert into LARGE_DATA (BIN_DATA, INSERT_TIME,
MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:55 DEBUG (GeronimoLog.java:66)     - prepareStatement: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:55 DEBUG (GeronimoLog.java:66)     - insert into LARGE_DATA (BIN_DATA, INSERT_TIME,
MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:55 DEBUG (GeronimoLog.java:66)     - prepareStatement: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:56 DEBUG (GeronimoLog.java:66)     - insert into LARGE_DATA (BIN_DATA, INSERT_TIME,
MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:56 DEBUG (GeronimoLog.java:66)     - prepareStatement: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:56 DEBUG (GeronimoLog.java:66)     - insert into LARGE_DATA (BIN_DATA, INSERT_TIME,
MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:56 DEBUG (GeronimoLog.java:66)     - prepareStatement: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:56 DEBUG (GeronimoLog.java:66)     - insert into LARGE_DATA (BIN_DATA, INSERT_TIME,
MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:56 DEBUG (GeronimoLog.java:66)     - prepareStatement: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:56 DEBUG (GeronimoLog.java:66)     - Commiting on org.apache.geronimo.transaction.manager.GeronimoTransactionManager@10b755d...
>  07-28@15:31:56 DEBUG (GeronimoLog.java:66)     - insert into LARGE_DATA (BIN_DATA, INSERT_TIME,
MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:56 DEBUG (GeronimoLog.java:66)     - prepareStatement: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@15:31:56 DEBUG (GeronimoLog.java:66)     - insert into LARGE_DATA (BIN_DATA, INSERT_TIME,
MLOCK, ID) values (?, ?, ?, ?)
> Here, in each copy operation Hibernate flushes dirty records to database, because of
sql query for variable. 
> for ODE-trunk:
>  07-28@16:17:10 DEBUG (AbstractEntityPersister.java:2777)     -  Insert 0: insert into
LARGE_DATA (BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:14 DEBUG (SimpleScheduler.java:155)     - Beginning a new transaction
>  07-28@16:17:15 DEBUG (SimpleScheduler.java:170)     - Commiting...
>  07-28@16:17:15 DEBUG (SimpleScheduler.java:155)     - Beginning a new transaction
>  07-28@16:17:15 DEBUG (SimpleScheduler.java:170)     - Commiting...
>  07-28@16:17:18 DEBUG (SQLStatementLogger.java:111)     - insert into LARGE_DATA (BIN_DATA,
INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:18 DEBUG (LoggingInterceptor.java:148)     - prepareStmt: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:18 DEBUG (SQLStatementLogger.java:111)     - insert into LARGE_DATA (BIN_DATA,
INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:18 DEBUG (LoggingInterceptor.java:148)     - prepareStmt: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:19 DEBUG (SQLStatementLogger.java:111)     - insert into LARGE_DATA (BIN_DATA,
INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:19 DEBUG (LoggingInterceptor.java:148)     - prepareStmt: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:19 DEBUG (SQLStatementLogger.java:111)     - insert into LARGE_DATA (BIN_DATA,
INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:19 DEBUG (LoggingInterceptor.java:148)     - prepareStmt: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:19 DEBUG (SQLStatementLogger.java:111)     - insert into LARGE_DATA (BIN_DATA,
INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:19 DEBUG (LoggingInterceptor.java:148)     - prepareStmt: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:19 DEBUG (SQLStatementLogger.java:111)     - insert into LARGE_DATA (BIN_DATA,
INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:19 DEBUG (LoggingInterceptor.java:148)     - prepareStmt: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:19 DEBUG (SQLStatementLogger.java:111)     - insert into LARGE_DATA (BIN_DATA,
INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:19 DEBUG (LoggingInterceptor.java:148)     - prepareStmt: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:19 DEBUG (SQLStatementLogger.java:111)     - insert into LARGE_DATA (BIN_DATA,
INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:19 DEBUG (LoggingInterceptor.java:148)     - prepareStmt: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:20 DEBUG (SQLStatementLogger.java:111)     - insert into LARGE_DATA (BIN_DATA,
INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:20 DEBUG (LoggingInterceptor.java:148)     - prepareStmt: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:20 DEBUG (SQLStatementLogger.java:111)     - insert into LARGE_DATA (BIN_DATA,
INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:20 DEBUG (LoggingInterceptor.java:148)     - prepareStmt: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:20 DEBUG (SQLStatementLogger.java:111)     - insert into LARGE_DATA (BIN_DATA,
INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:20 DEBUG (LoggingInterceptor.java:148)     - prepareStmt: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:20 DEBUG (SQLStatementLogger.java:111)     - insert into LARGE_DATA (BIN_DATA,
INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:20 DEBUG (LoggingInterceptor.java:148)     - prepareStmt: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:20 DEBUG (SQLStatementLogger.java:111)     - insert into LARGE_DATA (BIN_DATA,
INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:20 DEBUG (LoggingInterceptor.java:148)     - prepareStmt: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:20 DEBUG (SQLStatementLogger.java:111)     - insert into LARGE_DATA (BIN_DATA,
INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:20 DEBUG (LoggingInterceptor.java:148)     - prepareStmt: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:20 DEBUG (SQLStatementLogger.java:111)     - insert into LARGE_DATA (BIN_DATA,
INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:20 DEBUG (LoggingInterceptor.java:148)     - prepareStmt: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:20 DEBUG (SQLStatementLogger.java:111)     - insert into LARGE_DATA (BIN_DATA,
INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:20 DEBUG (LoggingInterceptor.java:148)     - prepareStmt: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:21 DEBUG (SQLStatementLogger.java:111)     - insert into LARGE_DATA (BIN_DATA,
INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:21 DEBUG (LoggingInterceptor.java:148)     - prepareStmt: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:21 DEBUG (SQLStatementLogger.java:111)     - insert into LARGE_DATA (BIN_DATA,
INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:21 DEBUG (LoggingInterceptor.java:148)     - prepareStmt: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:21 DEBUG (SQLStatementLogger.java:111)     - insert into LARGE_DATA (BIN_DATA,
INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:21 DEBUG (LoggingInterceptor.java:148)     - prepareStmt: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:21 DEBUG (SQLStatementLogger.java:111)     - insert into LARGE_DATA (BIN_DATA,
INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:21 DEBUG (LoggingInterceptor.java:148)     - prepareStmt: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:21 DEBUG (SQLStatementLogger.java:111)     - insert into LARGE_DATA (BIN_DATA,
INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:21 DEBUG (LoggingInterceptor.java:148)     - prepareStmt: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:21 DEBUG (SQLStatementLogger.java:111)     - insert into LARGE_DATA (BIN_DATA,
INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:21 DEBUG (LoggingInterceptor.java:148)     - prepareStmt: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:21 DEBUG (SQLStatementLogger.java:111)     - insert into LARGE_DATA (BIN_DATA,
INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:21 DEBUG (LoggingInterceptor.java:148)     - prepareStmt: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:22 DEBUG (SQLStatementLogger.java:111)     - insert into LARGE_DATA (BIN_DATA,
INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:22 DEBUG (LoggingInterceptor.java:148)     - prepareStmt: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:22 DEBUG (SQLStatementLogger.java:111)     - insert into LARGE_DATA (BIN_DATA,
INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:22 DEBUG (LoggingInterceptor.java:148)     - prepareStmt: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:22 DEBUG (SQLStatementLogger.java:111)     - insert into LARGE_DATA (BIN_DATA,
INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:22 DEBUG (LoggingInterceptor.java:148)     - prepareStmt: insert into LARGE_DATA
(BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
>  07-28@16:17:22 DEBUG (SQLStatementLogger.java:111)     - insert into LARGE_DATA (BIN_DATA,
INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?)
> Here's somewhat better, because inserts are done after commit, but still there's to lot
of them. 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message