Path: utzoo!attcan!uunet!husc6!mailrus!ames!pasteur!agate!violet.berkeley.edu!steve
From: steve@violet.berkeley.edu (Steve Goldfield)
Newsgroups: comp.databases
Subject: Re: Ingres docopy
Message-ID: <15479@agate.BERKELEY.EDU>
Date: 14 Oct 88 17:35:14 GMT
References: <412@rhesus.primate.wisc.edu>
Sender: usenet@agate.BERKELEY.EDU
Organization: University of California, Berkeley
Lines: 20

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 in version 5 as
#>compared to version 3?  I thought perhaps it was just slow writing
#>to files if the format list was given, but it's not much better
#>doing a bulk copy.  Is there something I can tweak to speed it up?
#>
#>Paul DuBois
#>dubois@primate.wisc.edu	rhesus!dubois
#>bin@primate.wisc.edu	rhesus!bin

We've had the same experience here. Our Ingres cpu charges
are exorbitantly high (on a Vax 8650). I got a detailed list
of charges and found that docopy was one big offender.
Quels on multiple tables was the other. The strange thing
is that running reports is very cheap. So you could presumably
generate a text file with a report for $.15 or so or copy to
a text file for about $15. I haven't tried doing both on the
same file, though.

Steve Goldfield