Page 1 of 1
Report Performance, R&R 8.0 and VFP 8
Posted: Thu Sep 01, 2011 4:04 pm
by Jeff_Barefoot_(Guest)
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
=> RE: Report Performance, R&R 8.0 and VFP 8
Posted: Tue Oct 04, 2011 5:37 pm
by Jeff_Barefoot_(Guest)
Does anyone have any thoughts on this? Can indexes from the underlying tables be used in any way to improve report performance?____Thanks,____Jeff
==> RE: Report Performance, R&R 8.0 and VFP 8
Posted: Sun Oct 23, 2011 8:22 pm
by kfleming
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
===> RE: Report Performance, R&R 8.0 and VFP 8
Posted: Mon Oct 31, 2011 11:05 pm
by cstrasser
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.