Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <33322462.114941283347253383.JavaMail.jira@thor>
Date: Wed, 1 Sep 2010 09:20:53 -0400 (EDT)
From: "Rick Hillegas (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Created: (DERBY-4788) Automatically apply the bulk-insert
 optimization when the size of the source stream warrants it.
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

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.