Look at the query plan from the Report. It is probably doing more than
it has to do. A tool like IBPlanalyzer will help.

Adam

--- In firebird-support@yahoogroups.com, Robert martin <rob@c...> wrote:
> Hi
>
> When running a crystal report against firbird 1.5.xx super server.
It
> is a complex report and FB CPU usage jumps to 99%. This seems to
cause
> all other applications connected to this database to freeze ! Any
> suggestions? I am going to look at the report and see if its
> performance can be improved.
>
> --
> Rob Martin
> Software Engineer
>
> phone +64 03 377 0495
> fax +64 03 377 0496
> web www.chreos.com
>
> Wild Software Ltd