Subject RE: [ib-support] High CPU usage AFTER bulk insert completed
Author Mike Grover
A lilttle FYI, I have Inserted 40 gig External files in a single commit
and have not run out of memory....

This was with no Indexes...


-----Original Message-----
From: Ann W. Harrison [mailto:aharrison@...]
Sent: Wednesday, March 20, 2002 11:09 AM
Subject: Re: [ib-support] High CPU usage AFTER bulk insert completed

At 12:01 PM 3/20/2002 +0800, Kenneth wrote:

> my code code creates a prepared
>everytime i perform the insertion. (This limitation is unfortunately, due to
>the fact the
>Type4 FB JDBC driver doesn't support reusing a statement after commits)

Are you also doing a commit after each insert? That's making things
slower than they need to be ... at least in most cases.

>Just wondering if this has something to do with some internal memory
>But then again, it's just 2000 prepared statements. It can't possibly take
>25 seconds to free them all right?

Have you traced the memory usage of the server?


We have answers.

------------------------ Yahoo! Groups Sponsor ---------------------~-->
Tiny Wireless Camera under $80!
Order Now! FREE VCR Commander!
Click Here - Only 1 Day Left!

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to