Hi friends.

I'm working in a COM that, in one of its classes, there's a method which launches the following SQL code:

SELECT			 ;
	loja		,;
	data		,;
	qtd_lanca	,;
	qtd_saldo	 ;
FROM 			 ;
	g2_estmo	 ;
WHERE 		 	 ;
	g2_estmo.codigo = cCodigo  ;
        &lcFiltro                  ;
INTO TABLE                         ;
	(lcNomeArq) READWRITE

The memvars lcNomeArq,cCodigo and lcFiltro are properly initialized.

And here's my issue. This table has 1,500,000, and i'm testing the worse of the situations possible for this table: a value for cCodigo which returns me a result table of 24296 records. Testing in the same machine with the same OS in the same nethood, exactly the same SQL code with exactly the same table I get this result with the following times:

From the Command Window: 1min41secs
From the COM : 5 minutes

May someone Help me? it's is critical

TIA,