Re: slow migration path

codefragment@xxxxxxxxxxxxxx wrote:
On 27 Oct, 18:38, codefragm...@xxxxxxxxxxxxxx wrote:
Sorry, ignore this, the problem seemed to be the garbage collecting. I
now call GC.Collectand it does about 300 rows a second

<doh><blush>Also, if you are going to insert 3 million rows into a
table it might be an idea to remove the index on that table first.</
blush></doh>

For only 3 million rows? Likely just a waste of time.
--
Daniel A. Morgan
University of Washington
damorgan@xxxxxxxxxxxxxxxx (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.

Relevant Pages