OK .. thanks!!!

> Hi Rafael!
>
> I doubt your application freezes, most likely it is just taking a lot
> of time. Whatever the reason, it is most likely something to do with
> Firebird/Interbase, and not IBO. Ask this question in firebird-support
> and add some information about plan, table sizes, indexes etc.
>
> Set
>
> --- In IBObjects@yahoogroups.com, "Rafael Colucci" wrote:
> > Hi
> >
> > I´m having problems with a query, when the query have many "joins"
> > and I place the clause "order by" the application freeze. In
> > IBExpert freeze too. The query compiles, but does not execute.
> > Somebody had a similar problem, can give some tip?
> > The Query is this:
> >
> > SELECT * FROM Pasta
> > LEFT JOIN Processo ON Pasta.idPasta = Processo.idPastaProc
> > LEFT JOIN Jurisdicao
> > ON Jurisdicao.idJurisdicao = Processo.idJurisdicao
> > LEFT JOIN Pessoa PessoaCliente
> > ON Pasta.idPesCliPrinc = PessoaCliente.idPessoa
> > LEFT JOIN Pessoa PessoaJuizo
> > ON PessoaJuizo.idPessoa = Processo.idPessoaJuizo
> > LEFT JOIN Pessoa PessoaContr
> > ON PessoaContr.idPessoa = Processo.idPesAdversoPrinc
> > LEFT JOIN TipoAcao ON TipoAcao.idTipoAcao = Processo.idTipoAcaoProc
> > RIGHT JOIN Compromisso
> > ON Pasta.idPasta = Compromisso.idPastaCompromisso
> > LEFT JOIN Pessoa PessoaCompr
> > ON PessoaCompr.idPessoa = Compromisso.idPessoaCompromisso
> > ORDER BY pasta.idpasta
> >
> > thanks for help
> > Rafael Colucci
>
>
>
>
>

___________________________________________________________________________

> IB Objects - direct, complete, custom connectivity to Firebird or

InterBase

> without the need for BDE, ODBC or any other layer.
>

___________________________________________________________________________

> http://www.ibobjects.com - your IBO community resource for Tech Info

papers,

> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>
>