I've seen Crystal 11 generate some pretty idiotic queries, which take
hours to complete, but our database is still useable. We're running FB
1.5.2 super server on Redhat 9 on a dual-Xeon box.

Rick DeBay

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Robert martin
Sent: Monday, June 27, 2005 5:02 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Crystal reports and firebird

We have already deployed to some users (FB 1.5). We have only recently
identified this as an issue. Is there really nothing that can be done,
I take it IB has the same issue? How soon until FB 2 goes beta?

Rob Martin
Software Engineer

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

Wild Software Ltd



buppcpp@... wrote:

>
>
>>"Robert martin" <rob@...> wrote in message
>>
>>
>news:<42BF8743.2040706@...>...
>
>
>
>>It seems that FB isn't good at sharing its resources?
>>
>>
>
>You are correct in this assumption.
>We haven't went into production with FB 1.5.2 yet, but our testing has
>shown us that regardless of it's mutlti-version architecture, this
>database is horrible in speed and concurrency when compared to it's

"page locking"

>competitors.
>
>FB2 is much, much better. Dimitry and crew have done a great job with

it.

>It still has some problems, but it's a move in the right direction.
>
>If it is at all possible, wait until FB2, because I don't think they
>care about improving FB 1.5.2 for it's users that are currently

suffering.

>
>I hope they will prove me wrong VERY, VERY, SOON, but at this point I
>"think" we are going to move to PostgresSQL, it has shown some
>promising results.
>
>Thanks
>
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>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
>
>
>
>
>
>
>
>
>

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

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