Re: Performance problem

From: <soverby_at_nspr.com>
Date: Tue, 14 Apr 1998 07:49:10 -0600
Message-ID: <6gvm06$ro8$1@nnrp1.dejanews.com>

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 Received on Tue Apr 14 1998 - 08:49:10 CDT