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

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

Because our App is (in reality) doing OLTP. Inserts are normally done (and comitted) one at a time.

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 Received on Mon Jun 27 2005 - 11:00:36 CDT