Re: Performance problem

From: <bialik_at_wis.weizmann.ac.il>
Date: Tue, 14 Apr 1998 13:17:06 -0600
Message-ID: <6h0971$n6n$1@nnrp1.dejanews.com>

Use DirectPath Loader ( if you are not already using it ).

Michael.

In article <6gvm06$ro8$1_at_nnrp1.dejanews.com>, soverby_at_nspr.com wrote:
>
> Try dropping the indexes before the import and then re-create after import
is
> done.
>
> In article <6gv7am$7dn$1_at_peuplier.wanadoo.fr>,
> "Aldo Calzolari" <Aldo.calzolari_at_hol.fr> wrote:
> >
> > I have to insert 600,000 rows into a table. There is no problem for the
> > first 150,000 rows and after the import procedure becomes slow, VERY slow
> > (at the beginning, 100 rows are processed in approx. 20 s, after 150,000,
1
> > row requires 4 sec.).
> >
> > I have no problem at all with my indexes and my datafiles, I've checked
> > everything and all seems normal.
> >
> > Any help would be appreciated,
> > thank you
> >
> > Aldo Calzolari,
> > Net Valley, Paris, FR
> >
> >
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Apr 14 1998 - 14:17:06 CDT