run time

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

run time

Post by happydermis » Mon Apr 11, 2005 5:49 am

I have a report with a run time of about 50 minutes. Does this sound normal??____I can hardly debug the report since I must wait those 50 minutes until I can see if I did right or wrong with the report____Thanks, Dekers

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

=> RE: run time

Post by kfleming » Mon Apr 11, 2005 7:02 am

The complexity of the report, the size of the data files and the speed of the I/O will be the main factors that determine the time that it takes for a report to execute.____Kathleen__R&R Support

happydermis
Posts: 63
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: run time

Post by happydermis » Mon Apr 11, 2005 7:13 am

This is why I tried to keep my report as simple as possible and to use the minimum I need. Is it normal for reports to take such a long time or does my report need extremly long time to run?____

castrass
Posts: 14
Joined: Tue Oct 10, 2017 12:44 pm

===> RE: run time

Post by castrass » Tue Apr 12, 2005 2:28 pm

Keep in mind that reports with lots of total fields and summary bands will take longer in general as well. You don^t mention if it^s an Xbase or a SQL report. If Xbase, limit the scope to just a subset of the records in the master table. For SQL, limit it to the first N records.

happydermis
Posts: 63
Joined: Tue Oct 10, 2017 12:44 pm

====> RE: run time

Post by happydermis » Mon Apr 25, 2005 12:22 pm

thanks castrass,____I use the Xbase version (unfortunately...). The problem is: I don^t think it is possible to limit the scope of my report since I am using a multiple scan report. In this kind of report a ^pseudo^ table is used as the "main" linking table to two or more tables all in one scanning level. The scope of the pseudo table is being limited to 1 but as far as I know there is no way to limit the scan of tables on other levels.____Do you know anything about it? ____Thanks, Dekers____P.S - at this time I am looking at about 50 minutes per report, which is actually unuseable __

Post Reply