Problem with FastReports 2.53 - fast query but slow prepare OR slow query and fast prepare

Problem with FastReports 2.53 - fast query but slow prepare OR slow query and fast prepare

Post by Angelos Ar » Wed, 20 Feb 2008 00:07:05


Hello everyone,

I am using D7, FR 2.53 and a TIBQuery.

I have a report which takes a bit of time to preview, so I was trying to
make it faster. After playing aroung with the query's SQL statement I
managed to get its execution time down to ~3sec (from ~12sec).

But, now it takes a lot of time for the report's PrepareReport method to
complete. Before, when the query needed ~12sec, PrepareReport completed
almost instantly (< ~1sec)

Does anyone have any idea what this is happening?

Thank you in advance

Angelos