--- In IBObjects@y..., "Virtual Memory" <virtual@v...> wrote:

> After converting my BDE's application for IBO some selects stayed

much slowwer.

>
> Am I sending select and the properties specified in the component

TIBOQuery to see where am being mistaken?

>
>
> SELECT DISTINCT
>
> P.L010_CODIGO_BASE,
>
> P.L010_CODIGO,
>
> P.L010_CODIGO_SIMILARIDADE,
>
> P.L010_DESCRICAO,
>
> SUM(L.L250_QTD_ATUAL - L.L250_QTD_RESERVA) AS L010_DISPONIVEL
>
> FROM
>
> L010 P
>
> LEFT JOIN L250 L
>
> ON (P.L010_CODIGO = L.L250_L010_CODIGO)
>
> WHERE
>
> (P.L010_CODIGO_BASE LIKE :PRD1 OR
>
> P.L010_CODIGO LIKE :PRD2 OR
>
> P.L010_DESCRICAO LIKE :PRD3) AND
>
> (((L.L250_L305_CODIGO = 'A' ) OR
>
> (L.L250_L305_CODIGO = 'P' AND L.L250_DATA_ENTRADA <= :SEG_VEN AND
>
> L.L250_DATA_ENTRADA > :PRDL) OR
>
> (L.L250_L305_CODIGO IS NULL)) AND (L.L250_QTD_ATUAL >= 0 OR

L.L250_QTD_ATUAL IS NULL)) AND

>
> (L.L250_QTD_RESERVA >= 0 OR L.L250_QTD_RESERVA IS NULL)
>
> GROUP BY
>
> P.L010_CODIGO_BASE,
>
> P.L010_CODIGO,
>
> P.L010_CODIGO_SIMILARIDADE,
>
> P.L010_DESCRICAO

Your best bet is to download and use the absolutely fantastic
IBPlanAnalyzer by Craig Stuntz. I can't remember the URL but just do
a Google search for it.

Eric.