On May 4, 11:33 am, DA Morgan <damor..._at_psoug.org> wrote:
> EscVector wrote:
> > 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.
>
> Thanks for the clarification that, essentially, management doesn't
> understand what it is tasked with managing. Have you considered AQ?
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org
Yes to the extent of saying "what about AQ?" I'll take a look..
Received on Mon May 07 2007 - 08:59:37 CDT
