Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: slow migration path

Re: slow migration path

From: <codefragment_at_googlemail.com>
Date: Tue, 30 Oct 2007 11:41:40 -0700
Message-ID: <1193769700.586042.260600@57g2000hsv.googlegroups.com>


On 29 Oct, 15:33, DA Morgan <damor..._at_psoug.org> wrote:
> codefragm..._at_googlemail.com wrote:
> > On 27 Oct, 18:38, codefragm..._at_googlemail.com wrote:
> >> Sorry, ignore this, the problem seemed to be the garbage collecting. I
> >> now call GC.Collectand it does about 300 rows a second
>
> > <doh><blush>Also, if you are going to insert 3 million rows into a
> > table it might be an idea to remove the index on that table first.</
> > blush></doh>
>
> For only 3 million rows? Likely just a waste of time.
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

as I say, writing speed for a c# app to an oracle database on a home machine goes from 30 rows a second to 300 rows a second with 3 million rows if you remove the index. What sort of writing speed should I be expecting? Received on Tue Oct 30 2007 - 13:41:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US