Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grouping problem
Message
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
01338206
Message ID:
01340069
Views:
10
>OK, so speed is becoming a problem as the size of the data set increases. There are two places where things are really slow.
>
>1) The call to the UDF to update the page total cursor is the slowest part. The UDF is a prg that accepts the data for the fields as parameters and inserts them into the cursor--just 2 lines of code. Is there a faster way to do this? I've tried using Insert ... in the On Exit expression but apparently that's not allowed...

You can use _VFP.SetVar and use either array or collection (2 dimensional array seems to be simpler - one dimension for GroupID, another for PageNumber). May be it would give some speed improvement, hard to tell.

>
>2) I might not have noticed this one except for the previous issue but there are obviously 2 passes through the report. One pass goes to file but the other goes to the printer and is immediately deleted. Is there a way to eliminate the one to the printer? I thought there wouldn't be a second pass if _PageTotal wasn't being used. Perhaps I was mistaken.

I don't know the inner working of VFP report engine. It seems logical to not use the second pass if _PageTotal variable is not used, but may be the engine always does it? I don't want to speculate, don't know.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform