Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why would reports take a long time to display?
Message
 
To
03/11/2005 06:14:23
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:
01064890
Views:
30
This message has been marked as the solution to the initial question of the thread.
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?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform