Re: Fastest way to ASCII file or other ideas?

On May 4, 6:52 am, EscVector <J...@xxxxxxxxxxxx> wrote:
jg,
I'll post the stats. Still setting up.
Platform wise it has to run on any platform. I'll test on Win2003,
XP, AIX, Linux, Solaris and provide disk and setup specs.

Ah, now that defines the problem much more clearly. If you had
limited to unix/linux, there is a much less of a bottleneck writing to
files, as well as shell tools always being available.


I do like the sqlplus option and it is quite fast in my unmeasured
alpha tests, but I want to the possibly to fork out process and pseudo
parallelize the disk writes, stop and start the process, etc. I can
do this with SQLPLUS but I'm not a huge fan of calling an .exe when I
need programmatic control. This bias might be more personal than
technical, but I've seen lots of so called batch jobs that call
sqlplus and simply ignore exceptions and control issues. I prefer
event driven notification via a class object rather than in-line batch
process with goto like exceptions. I realize the WHENEVER SQLERROR/
OSERROR has some level of control but the default is to exit and I've
had trouble getting large batch process to behave or continue
correctly when using this.

Once you throw Win into the mix, your bias becomes much more sensible
technically, especially the batch issue.


Ultimately I'm only providing test detail; others will decide what
they like best. I just need to provide the options to the available
skill-sets.

Good luck!

jg
--
@home.com is bogus.
Happy to be absurdist.


.

Relevant Pages

  • Re: Fastest way to ASCII file or other ideas?
    ... Platform wise it has to run on any platform. ... do this with SQLPLUS but I'm not a huge fan of calling an .exe when I ... sqlplus and simply ignore exceptions and control issues. ... event driven notification via a class object rather than in-line batch ...
    (comp.databases.oracle.server)
  • Re: Fastest way to ASCII file or other ideas?
    ... Platform wise it has to run on any platform. ... XP, AIX, Linux, Solaris and provide disk and setup specs. ... sqlplus and simply ignore exceptions and control issues. ... event driven notification via a class object rather than in-line batch ...
    (comp.databases.oracle.server)
  • Re: Batch file extract from disk images?
    ... I want to point a batch ... do one disk at a time, ... options are there for batch file extraction? ... home dot woh dot rr dot com slash jbmatthews ...
    (comp.sys.apple2)
  • Re: Coax recomendations
    ... Hopefully, in the fullness of time, you will roll all this information ... it seems more difficult to control than ... If so, is it a batch to batch variation, ... variation of velocity factor from batch to batch of otherwise identical cable from the same manufacturer, as Owen's articles imply. ...
    (rec.radio.amateur.antenna)
  • Re: How can Linux demage a motherboard?
    ... I am not in a crusade against Linux, ... Considering your theory of faulty batch you need to put into consideration ... Could it be related to opening the case to install the other disk rather than what was on the disk? ... could it be a faulty disk that damaged the interface on the MB? ...
    (comp.os.linux.hardware)