Re: Oracle Objects for OLE Performance - help needed

From: Randall <aslan-zzz_at_pcmagic.net>
Date: Tue, 06 Oct 1998 09:06:54 -0700
Message-ID: <361A401C.16982050@pcmagic.net>

> ... after about 100,000 rows,
> the performance starts to grind to a halt such that a practical maximum of
> about 200,000 rows is realised. ie 100,000 rows = 10 seconds, 200,000 rows =
> 15 minutes.
>
> Why does performance degrade so quickly? The server itself is idle, and all
> the work is on the client.
>

 Just an educated guess... after about 100,000 rows maybe you are out of RAM and Virtual Memory kicks in. The swapping would explain the slowdown.

--
Best!

Randall

[Just my Dog and I at the Edge of the Universe]

---

(Remove "-zzz" from address when replying.)

---

Received on Tue Oct 06 1998 - 11:06:54 CDT