Re: MASSIVE degradation of insert using sequence ID's via JDBC on 9i?

bugbear wrote:
> HansF wrote:
>

>> On Mon, 27 Jun 2005 15:17:52 +0100, bugbear interested us by writing:
>>
>> Curious - why are you committing after each insert (inside the loop)? 
>> While there may be legit reasons, based on your description I don't
>> understand the need for it at that point, and it will certainly
>> slow things down

What does one have to do with the other? Please explain.

> Our application is NOT doing a "Bulk insert", even though
> our test is (sort of). We wanted the test to reflect our
> Application context.
>
> BugBear

Why isn't it?

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)