Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Odd Report Behavior
Message
From
30/01/2017 13:06:22
 
 
To
30/01/2017 12:49:51
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
01647175
Message ID:
01647178
Views:
60
>About 2 months ago, this client was hit by a severe virus and had to replace all programs.
>Fortunately the network people had good backups and utilities and the client was back up and running in a few hours.
>
>Since then - I'm not sure there is a connection with that event - one report that has been running OK for years prints a few pages and then, when a group changes, pauses for about 5 minutes before printing the next group's data, and repeats that pattern for all groups.
>
>The process used to take a few minutes, now it takes almost an hour.
>
>The app uses an exe that I create and upload. The report forms are not in the .exe.
>
>I'm suspecting the VFP dll that they restored, but that's just speculation.
>
>Any clues?

These days pretty much all Windows print jobs are spooled, so once the job has been generated it should print continuously with no pauses. If you're seeing long pauses it seems to me it's likely the workstation generating the job is pausing i.e. there are delays in processing.

What might cause that is likely dependent on exactly how you're generating that report. However, one thing that can slow down processing a lot is missing index tags. A while back I ran into a case where a CDX file had lost 6 of its 7 index tags, only the PK tag remained. That slowed processing down by over 100 times (i.e. speed without the tags was less than 1% of speed with the tags present).
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform