You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Rick Hillegas (JIRA)" <ji...@apache.org> on 2010/09/01 15:20:53 UTC

[jira] Created: (DERBY-4788) Automatically apply the bulk-insert optimization when the size of the source stream warrants it.

Automatically apply the bulk-insert optimization when the size of the source stream warrants it.
------------------------------------------------------------------------------------------------

                 Key: DERBY-4788
                 URL: https://issues.apache.org/jira/browse/DERBY-4788
             Project: Derby
          Issue Type: Improvement
          Components: SQL, Store
            Reporter: Rick Hillegas


Bulk-insert is a technique which allows Derby to avoid logging rows when the target table starts out empty. Right now only the import procedures use this technique. Users would see a performance boost if Derby automatically applied this technique whenever a large number of rows were inserted into an empty table. Extensive discussion of the issues can be found on the following derby-dev email threads:

"bulk insert"
"is there some way to support bulk insert without new syntax, in a zero admin way?"

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