First run of report (after reboot) from Delphi app is slow

[bmarks]

Environment:
Application written in Delphi
Crystal 9
Datasource is Interbase stored procedure

The Delphi application passes parameters to the report, which passes them to the InterBase stored procedure.

After a reboot of the PC, the first time the user chooses this report in the Delphi app, it takes over 3 minutes to run. If they run it again (with same or different parameters), it takes 10 to 15 seconds to run. If application is exited and restarted, it still runs in less than 15 secs. However, if the PC is rebooted, it will then take over 3 minutes again.

Anyone have any ideas why this would happen and if there is any way to fix it?

Thanks

 

[bmarks]

I found the issue. Under File, Options the following were checked in the Database tab:

- verify on first refresh
- verify stored procedure on first refresh
- verify when database driver upgraded

I had checked these during troubleshooting.

I unchecked these and now the report runs quickly on the first run after reboot.