Re: fastest method to copy data between databases

Thanks to everyone for their responses. I've tried incorporating arraysize and copycommit into the COPY command without appreciable effect. I've also experimented with SQL*Loader and find that the load is VERY fast. The bottleneck is still in the query to extract the data.

Looking at the query (select * from [view]), I notice that if all or most of the fields are selected, I get a start/stop behavior that acts as if a buffer is being filled. Using SQLPlus, about 20 records will display followed by a pause for 5 seconds, then the next 20, and so on. If I only select a few fields, the display is continuous. I eliminated the functions from the view so they aren't the cause. I also see this behavior on another much smaller database on the same machine. The behavior seems to persist during time of low usage.

Has anyone else experienced this behavior?

David Pelinka - Programmer/Analyst	Direct/Voice: (503)-977-4379
Portland Community College, SY CC 224	Fax: (503)-977-4987
PO Box 19000 Portland, OR. 97280-0990	Internet: dpelinka_at_pcc.edu


--------------------------------------------------------------------