Re: Rows Imported per min
From: Steve Butler <sbut-is_at_seatimes.com>
Date: 1996/05/09
Message-ID: <Pine.SUN.3.91.960509122534.16965A-100000_at_seatimes>#1/1
Date: 1996/05/09
Message-ID: <Pine.SUN.3.91.960509122534.16965A-100000_at_seatimes>#1/1
On Wed, 8 May 1996, Sameer Utrankar wrote:
> I am trying to get an average speed of import in terms of number of
> rows per min. It could depend on several factors and cannot really be
> a specific number but just to get an idea :
> high/low etc. It seems import is nowhere near sql loader speed.
sqlldr with DIRECT = TRUE is orders of magnitude faster than sqlldr without. import is orders of magnitude slower than sqlldr without DIRECT = TRUE.
I always look for some other way than to use exp/imp for any table of significant size. export even runs slower than I'd expect.
+----------------------------------------------------+ | Steve Butler Voice: 206-464-2998 | | The Seattle Times Fax: 206-382-8898 | | PO Box 70 Internet: sbut-is_at_seatimes.com | | Seattle, WA 98111 Packet: KG7JE_at_N6EQZ.WA | +----------------------------------------------------+All standard and non-standard disclaimers apply. All other sources are annonymous. Received on Thu May 09 1996 - 00:00:00 CEST