db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sunitha Kambhampati (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-232) Open Invitation to add a Question and Answer to Derby FAQs
Date Tue, 31 May 2005 19:57:57 GMT
     [ http://issues.apache.org/jira/browse/DERBY-232?page=comments#action_66660 ]
Sunitha Kambhampati commented on DERBY-232:

Q.Are there any tips to make derby go faster ?
1)Use PreparedStatement with dynamic markers('?') instead of Statement. This will be faster
since the statement does not need to be recompiled every time

2) Avoid inserts in autocommit mode if possible: 
Inserts can be painfully slow in autocommit mode. The reason is that each commit involves
a flush of the log to the disk for each insert statement. The commit will not return until
a physical disk write has been executed. 
So to speed things up, run in autocommit false mode and execute a number of inserts in one
transaction and then explicitly issue a commit. 

> Open Invitation to add a Question and Answer to Derby FAQs
> ----------------------------------------------------------
>          Key: DERBY-232
>          URL: http://issues.apache.org/jira/browse/DERBY-232
>      Project: Derby
>         Type: Task
>   Components: Web Site
>     Reporter: Jean T. Anderson
>     Assignee: Jean T. Anderson
>     Priority: Trivial

> Add a comment to this Jira issue with the FAQ entry (both the question and the answer)
you would like to be added to http://incubator.apache.org/derby/faq.html, and the assignee
will add it.
> Indicate in your comment if the FAQ belongs in the "Developing Derby" or "Using Derby"

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
For more information on JIRA, see:

View raw message