Report Performance, R&R 8.0 and VFP 8

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Jeff_Barefoot_(Guest)
Posts: 15
Joined: Tue Oct 10, 2017 12:44 pm

Report Performance, R&R 8.0 and VFP 8

Post by Jeff_Barefoot_(Guest) » Thu Sep 01, 2011 4:04 pm

We have an application that tightly integrates R&R 8.0. Table sizes are modest for the most part, but several are getting a little bigger (140,000 records). Reports typically relate 3 or 4 VFP 8 tables together with the requesite sorting, grouping and querying.____We^re currently seeing about 3-4 minutes to run a report against the larger tables. Any thoughts as to how we can improve on that? We have full control over the VFP indexes and can add them as needed...is there any way to speed the reports up by adding indexes? ____Thanks,____Jeff

Jeff_Barefoot_(Guest)
Posts: 15
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Report Performance, R&R 8.0 and VFP 8

Post by Jeff_Barefoot_(Guest) » Tue Oct 04, 2011 5:37 pm

Does anyone have any thoughts on this? Can indexes from the underlying tables be used in any way to improve report performance?____Thanks,____Jeff

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: Report Performance, R&R 8.0 and VFP 8

Post by kfleming » Sun Oct 23, 2011 8:22 pm

The index will only help if it is set on the master table and you are not doing any additional sorting.____Kathleen__R&R Support

User avatar
cstrasser
Posts: 155
Joined: Tue Oct 10, 2017 12:44 pm

===> RE: Report Performance, R&R 8.0 and VFP 8

Post by cstrasser » Mon Oct 31, 2011 11:05 pm

It depends on your report structures as well. If you^re doing a lot of scanning between tables, you might generate more records to plow through than you expect (because of the underlying reportset). Maybe we could review some of your reports online.
Chris Strasser
Liveware Publishing, Inc.
Work bigger.

Post Reply