On May 3, 5:48 pm, DA Morgan <damor..._at_psoug.org> wrote:
> 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
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org
The issue is physical, since a "file" doesn't exist and the program
needs a file, management feels that it would not pass audit standards
that could result in billing or other legal issues related to the data
transfer. Essentially the file is a log of what was loaded. They
don't trust piping it into the app straight from the database. From
my point, it ain't' worth the fight.
Received on Fri May 04 2007 - 08:31:48 CDT
