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
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri May 04 2007 - 10:33:17 CDT
