Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Slow reports in 9.0
Message
From
30/08/2005 15:58:49
Dorin Vasilescu
ALL Trans Romania
Arad, Romania
 
 
To
30/08/2005 10:14:18
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
01045033
Message ID:
01045299
Views:
29
Hi
I've seen this behavior in VFP9 with certain printer drivers.

I have a open source product installed, PDFCreator. This installs a virtual PS printer in system. If this printer is the default printer, the preview of wrapping.frx from samples/reports takes a lot of time and eats 250MB of memory (for 8 pages only). If I use:
SET PRINTER TO NAME "Microsoft Office Document Image Writer"
REPORT FORM wrapping.frx TO PRINTER PROMPT PREVIEW
the report is rendered very fast.

And there is more
During report output process, the DoStatus method of Listener is called many, many times, even if the PercentDone is incremented by a small margin (0.0023, 0.0031, etc, proportionally with the number of records from source cursor). This lead to unnecessary execution of code in that method and a delay in execution because the thermometer.

Maybe you can change somthing in printer driver (resolution, optiumisation). I believe that is not only yhe VFP fault here.

>Thanks to everyone for their help. I've tried incorporating several of the good suggestions and here is what I get. The report is 11-12 pages long depending on the version. Printer environment is NOT saved, the report has been packed. All times listed below are to PREVIEW. In all cases the same exact code is running. In each case of 9.0, ENGINEBEHAVIOR is set to 70.
>
>FOXPRO 7.0: Less than 1 second, no time difference when previewing from page to page.
>
>FOXPRO 9.0, reportbehavior = 80: 64 seconds, previewing to the next page takes just as long.
>
>FOXPRO 9.0, report behavior = 90, using reportoutput.app and reportpreview.app that come with VFP: 400 seconds
>
>Again, the report has no pictures or graphics.
Previous
Reply
Map
View

Click here to load this message in the networking platform