Query quick but report slow
Is there somebody that could assist me to make my reports faster? I use Firebird and Delphi 6 and Fast Reports 4.
I create a query (from four tables) in Delphi that run within a few seconds creating about 1060 records. I want to print the records and group them on one of the fields.
When I select the report in the program, it takes very long (I left it for more than 20-30 minutes) to create the list and still do generate the report. I tested the SQL of the query and when I create it directly on the database it creates the query in a few seconds. I selected the query as the datasource for the report.
Is there a "trick" to make the generating of the report from a query faster?
Please help!
I create a query (from four tables) in Delphi that run within a few seconds creating about 1060 records. I want to print the records and group them on one of the fields.
When I select the report in the program, it takes very long (I left it for more than 20-30 minutes) to create the list and still do generate the report. I tested the SQL of the query and when I create it directly on the database it creates the query in a few seconds. I selected the query as the datasource for the report.
Is there a "trick" to make the generating of the report from a query faster?
Please help!
Comments
Yes, I did!