Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why would reports take a long time to display?
Message
From
03/11/2005 13:17:36
 
 
To
03/11/2005 12:08:22
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01064884
Message ID:
01065079
Views:
35
This is no "fix", just a way to see where the problem really comes from. By setting reportbehavior 80, you give up most of the best features of VFP9! It's like driving downhill, your car goes much faster than normal, but sooner or later you have to drive uphill again. :-)

By the way, I don't use the report engine in VFP9 at all, I use Rich Simpson's Mind's Eye Report Engine Control, http://www.mindseyeinc.com/ReportEngine/index.htm. It's much faster, and has a ton of extra features.

>Nice one. So nice when there's a simple fix. Godnose how we were supposed to figure that out for ourselves. How did you come across that little "feature"?
>
>>New report engine takes more time for rendering pages, Try with
>>SET REPORTBEHAVIOUR 80 to see if the speed is changed.
>>
>>
>>
>>>even with trivial datasets on a standalone machine.
>>>
>>>Even from the command line, if I run
>>>
>>>REPORT FORM XXX PREVIEW IN SCREEN
>>>
>>>for a trivial report with a few hundred records
>>>
>>>it can take up to a minute to display the result.
>>>
>>>If I immediately repeat the command, it will typically halve the time.
>>>
>>>After four or five attempts, it is instantaneous.
>>>
>>>So it is clearly behaving like there is some kind of cacheing issue but on such trivial reports and trivial amounts of local data, this doesn't make sense.
>>>
>>>It's only been an issue since VFP9 and it seems to be more of a problem for me than my clients (fortunately - or they'd be ripping me apart!) Which suggests its something to do with the VFP environment but I can't track it down.
>>>
>>>Any suggestions?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform