Re: Rows Imported per min

Sameer,

I have a piece of string wound into a tight ball of unkwown dimensions, any ideas how long it might be ??

This news group is getting ridiculous.
Instead of people with complex problems who have tried every other avenue we get people who can't be bothered to open a manual or who expect readers to have god like powers.

Yours unpresciently,

Sean Walters DBA
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 :
>
> I am getting 10,000 to 12,000 per min for a table. I believe indexes,
> constraints should not matter if import creates them as they will be
> created at the end of the data import phase. (If those exist while
> importing rows - it's a different question all together but that's not
> what I am doing).
>
> Any other numbers ? Any comments on whether these numbers look,
> high/low etc. It seems import is nowhere near sql loader speed.
>
> I am on HP-UX 10 and Oracle rdbms 7.2.3.
> --------------------------------------------
> Utrankas_at_coned.com (Sameer Utrankar)
Received on Fri May 10 1996 - 00:00:00 CEST