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...

mike

-----Original Message-----
From: Ann W. Harrison [mailto:aharrison@...]
Sent: Wednesday, March 20, 2002 11:09 AM
To: ib-support@yahoogroups.com
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
>statement
>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
>management?
>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?



Regards,

Ann
www.ibphoenix.com
We have answers.


------------------------ Yahoo! Groups Sponsor ---------------------~-->
Tiny Wireless Camera under $80!
Order Now! FREE VCR Commander!
Click Here - Only 1 Day Left!
http://us.click.yahoo.com/nuyOHD/7.PDAA/yigFAA/67folB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/