[DERBY-4788] Automatically apply the bulk-insert optimization when the size of the source stream warrants it.

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: SQL, Store
• Labels: derby_triage10_10
• Urgency: Normal
• Bug behavior facts: Performance
• Assignee: Unassigned
• Reporter: Richard N. Hillegas
• Created: 01/Sep/10 13:19
• Updated: 28/Sep/12 18:29

Description

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?"

Issue Links

• incorporates: DERBY-4789 Always apply the bulk-insert optimization when inserting from a table function.
• is related to: DERBY-268 Add Support for truncate table
• relates to: DERBY-5403 implement further syntax for truncate table support - identityBehavior clause