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 Bryan Pendleton <bp...@gmail.com> on 2010/09/01 03:15:13 UTC

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

>> I think that I would be satisfied with something less ambitious: If
>> the source stream for the INSERT involves a table function, then
>> always attempt a bulk insert--naturally, the bulk insert optimization
>> would be applied only if the target table was empty. This wouldn't

+1 to improved performance with no non-standard language changes!

+1 also to the suggestion of Knut Anders to enable a standards-compliant
TRUNCATE TABLE and then gain import speed that way.

The entire discussion has been interesting and instructive, thank you
for helping us understand the issues, even though the rest of us aren't
commenting :)

thanks,

bryan

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

Posted by Rick Hillegas <ri...@oracle.com>.
Thanks to everyone for the additional discussion. I have logged two 
issues based on our consensus:

DERBY-4788 - Master issue for automatically applying the bulk-insert 
optimization when inserting large data sets into empty tables.
DERBY-4789 - Always apply the bulk-insert optimization when the source 
stream involves a table function.

Thanks,
-Rick

Bryan Pendleton wrote:
>>> I think that I would be satisfied with something less ambitious: If
>>> the source stream for the INSERT involves a table function, then
>>> always attempt a bulk insert--naturally, the bulk insert optimization
>>> would be applied only if the target table was empty. This wouldn't
>
> +1 to improved performance with no non-standard language changes!
>
> +1 also to the suggestion of Knut Anders to enable a standards-compliant
> TRUNCATE TABLE and then gain import speed that way.
>
> The entire discussion has been interesting and instructive, thank you
> for helping us understand the issues, even though the rest of us aren't
> commenting :)
>
> thanks,
>
> bryan
>


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

Posted by "Dag H. Wanvik" <da...@Oracle.com>.
Bryan Pendleton <bp...@gmail.com> writes:

> The entire discussion has been interesting and instructive, thank you
> for helping us understand the issues, even though the rest of us aren't
> commenting :)

+1

Dag