Report Performance, R&R 8.0 and VFP 8

[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

[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

[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

[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.