Re: slow reportwriter

In article <3eco4t$f9g_at_hsc.usc.edu>, mcitron_at_hsc.usc.edu (Mark Citron) writes:
|> I have a report written in reportwriter that has 12 subqueries but
|> nothing unusual (master detail stuff). It retrieves 23 records and runs
|> against Oracle 6.0.37 on SCO Unix.
|>
|> 1. If I direct the reportwriter output to the screen it takes about 20 seconds
|> to bring up the first record and less than one second to display
|> each succeeding record.
|>
|> 2. HOWEVER, if I direct the output to a file it takes about 25 MINUTES
|> to complete the query.
|>

Is the directory to which the report is being written on a local disk, or is it NFS mounted? If the latter try directing the report to a local directory such as /tmp.

Ian MacGregor                         (415) 926-3528            
Stanford Linear Accelerator Center     ian_at_slac.stanford.edu