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