Fastunload from CA can extract data from tables very fast, it by pass
database server, and scan the data file block directly. It can produce text
format or Oracle dump format.
George Wang
"DA Morgan" <damorgan_at_psoug.org> wrote in message
news:1178228912.774420_at_bubbleator.drizzle.com...
> joel garry wrote:
>
>> Sometimes the simplest way is the fastest way. I bet many people
>> would be interested in what you find in speed difference between
>> sqlplus and pro-c and perl. I suspect there won't be much, but
>> haven't tested in this century.
>> jg
>
> I'm in agreement in that I suspect there won't be much difference
> but haven't tested it in a very long time.
>
> SELECTing is not going to be faster no matter what tool you use.
> And writing isn't going to be faster either. So where is the
> speed difference from C or perl? Formatting perhaps.
>
> I'd be interested in why/how pipes would be affected by an auditing
> requirement.
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org
Received on Thu May 03 2007 - 23:24:34 CDT
