You are right, some of the SQL produced by the visual linker is
terrible. I have written a stored procedure to produce the correct
results for the report mentioned and now performance is improved to
about 20s max, with no 'locking up' of Firebird. However we have about
1000 reports I don't mind if 0.5% of our reports take 20s to run, I just
don't want them to freeze FB.

Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com

Wild Software Ltd



lysander_fb wrote:

>--- In firebird-support@yahoogroups.com, Robert martin <rob@c...> wrote:
>
>
>>auto generated by Crystal reports FB (SS 1.5.1.4481) seems to go up to
>>99% CPU utilization. When this occurs out FB application essentially
>>appears to come to a halt.
>>
>>
>
>I can only confirm what Miroslav was writing. Do NOT use the visual
>query-designer of CR for Firebird-databases. Write your own
>SQL-statements and enter them into the "new command"-field in the
>database assistant of CR.
>
>I have several really big and complex reports, at least so I thought
>until today :-)
>Because they all open in less than 2 or 3 seconds... and this is even
>via ODBC!
>I am just horrified to think about reports that could need 15 minutes...
>
>ciao,
>André
>
>
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Visit http://firebird.sourceforge.net and click the Resources item
>on the main (top) menu. Try Knowledgebase and FAQ links !
>
>Also search the knowledgebases at http://www.ibphoenix.com
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>