Re: Print speed using Report Builder

From: A. Robert Thompson (robert.thompson_at_jebcointernational.com)
Date: 08/02/04 

Date: Mon, 2 Aug 2004 10:58:47 -0400

Thanks for the ideas Jon, we will look into all of them.

I think the problem is that it is a double pass report as Ed has mentioned.
We include 'page x of y' on the bottom of each page so I guess this makes it
a double-pass and that slows things down big time.

Rob.

<Jon Grewer> wrote in message news:410bfc91$1@newsgroups.borland.com...
> 1. Are you sure that Report Builder is the bottle neck? Try timing the
> processing without printing the report. Maybe the bottle neck is the
> database processing. Check your SQL. Are you processing only the data
you
> need? Are you using any brute force searches? An additional strategic
> index might greatly speed things up.
>
> 2. Could the Windoze spooler just be slow? In this case it might be
allot
> cheaper just to get a faster computer or increase the ram to reduce
swapping
> or both.
>
> 3. The communication bandwidth to the printer could be the problem. Is
it
> serial, parallel, USB, or network? If this really is just a standard text
> only aging report then perhaps you would want to output your report in
ASCII
> text to the printer. This will greatly reduce the volume of traffic to
the
> printer and eliminate the graphics overhead of Report Builder or any
graphic
> oriented report maker (which is just about all of them). Plus, fixed
width
> fonts can make columns of number easier to read.
>
> Regards,
> -- Jon
> _____________________________________
> Remove my shoe size from my email address to reply.
> Jon12@Grewer.net
>
> ------------------------------------
> "A. Robert Thompson" <robert.thompson@jebcointernational.com> wrote in
> message news:410be669$1@newsgroups.borland.com...
> > Hello:
> >
> > We use Report Builder (lastest version) to print aged listings of
Accounts
> > Receivables for our clients at month end.
> > We are using Interbase with Delphi 7.
> >
> > It now takes over 2 hours to print less than 3000 pages using an HP 4300
> > duplex printer. Note: to avoid confusion, this means less than 1500
sheets
> > of paper.
> >
> > The printer is always 'waiting' for pages to be sent. We us the same
> printer
> > to print out mont end customer statements and it takes under an hour to
> > print 2000 individual pages.
> >
> > Bottom line is that Report Builder cannot drive the printer to its
maximum
> > output capacity.
> >
> > Is there a faster software available?
> >
> > Thank you.
> >
> > A.Robert Thompson
> > Montreal, Quebec, Canada.
> >
> >
>
>