Hello

Thanks for Help Ann.

"or to simplify the query." its a really complex, the view is result and
return solds of movimention. i'm work with maximum simplify query, and the
view have 235 lines. She contains UNIONS and GROUP BY and 30 relationship..
it's really complex.

An Store Procedure isv not applicated in this case... also for test.

But... the V2 of Firebird, is estable? A'm 220 clients use this database,
and the update is really complex.

I'm reforce the idea to test with more detals this erros, but is serius
problem and occurs frenquently.

Thanks for help... i'm waiting more help

On 5/16/06, Ann W. Harrison <aharrison@...> wrote:
>
> Kurt Schneider wrote:
> > Hello... An Ideia to resolve BAD BLR? The firebird have and
> configuration to
> > expand the number of relations permited.? Its really bad to database
> > utility, my project is serius affected for this problem, a time to other
> > database in stude.
> >
> > someone help is welcome.
>
> Without seeing your view and query definitions, it's hard to
> say how to fix the problem. One possibility is to download
> a Firebird 2 release candidate and see if the changes in the
> optimizer for V2 allow it to handle your query. Other than
> that, the choices are to emulate the query with a stored
> procedure that breaks it into separate statements or to
> simplify the query.
>
>
> Regards,
>
>
> Ann
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
> 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 your group "firebird-support<http://groups.yahoo.com/group/firebird-support>"
> on the web.
>
> - To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com<firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> - Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>
> ------------------------------
>



--
************************************************************************************
Kurt Schneider - [ Analista de Sistema ]
Especialista em Analise e Desenvolvimento de Software
ControlSoft - Assessoria e Desenvolvimento de Sistemas
e-mail: kjundia@...
"Quis custodiet ipsos custodes?" - Satirás - De Juvenal


[Non-text portions of this message have been removed]