Path: utzoo!attcan!uunet!seismo!sundc!pitstop!sun!decwrl!labrea!rutgers!uwvax!oddjob!mimsy!haven!vrdxhq!daitc!jkrueger
From: jkrueger@daitc.daitc.mil (Jonathan Krueger)
Newsgroups: comp.databases
Subject: Re: Ingres docopy
Message-ID: <196@daitc.daitc.mil>
Date: 14 Oct 88 18:03:52 GMT
References: <412@rhesus.primate.wisc.edu>
Reply-To: jkrueger@daitc.daitc.mil.UUCP (Jonathan Krueger)
Organization: Defense Applied Information Technology Center, Alexandria VA
Lines: 15

In article <412@rhesus.primate.wisc.edu> bin@rhesus.primate.wisc.edu
(Brain in Neutral) writes:
>Why is RTI Ingres docopy such an abysmal loser...
>Is there something I can tweak to speed it up?

Partial answer: try the text(0)delim output format.  Contrary to the
documentation (version 5.0 Quel reference manual, section 2.5.3.2),
this format omits trailing spaces.  (The document says this works only
for text datatypes).  I recommend text(0)nl as safest.  Yes, it's
tedious to maintain dump scripts written this way.  I may write a
script generator: anyone interested?

Why this is only a partial answer: it's still slow.

-- Jon