Reports speed

[Guest]

I have a report very complex and withs some subreports.

When I open it for the first time, the tim is about 40 sec. I close an I re
open it and teh time decrease a lot, from 40sec comes to 10 sec.

The other reports are the same.
How can I open the reports faster, like the second time (about 10sec.)?

Fo teh forms are the same.

thanks
José

 

[Peter R. Fletcher]

You probably can't. The first time you open a report in a given
session, the resources (queries, formats, data Tables) that it uses
have to be read in from disk. When you rerun it, everything (including
the data, for small to medium sized databases) is likely to still be
in memory, where it can be accessed much faster. If you do enough
other things in the interim to clear the "residue" of the Report out
of memory, you will find that it has slowed down again when you do run
it again.

I have a report very complex and withs some subreports.

When I open it for the first time, the tim is about 40 sec. I close an I re
open it and teh time decrease a lot, from 40sec comes to 10 sec.

The other reports are the same.
How can I open the reports faster, like the second time (about 10sec.)?

Fo teh forms are the same.

thanks
José

Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher