Pablo,

Let's say that your result from the command window is the best to achieve. That is, with your current network speed etc. It just needs the time for downloading the 24.296 recors, right ?

Now think in bottlenecks. From the command window it's the network, and from the COM it's ...
Now I don't know, because it already could be the comunication between the COM and your VFP underneath that. It could be a buffer problem as well.
In order to checkout the last, run a result with, say, 500 records, and look whether that result is more near to the result from the command window. If it is, it's some buffer overflowing. If it is not, look for something around the COM being the bottleneck.

A long shot would be that the COM is taking away the resources from the Windows-OS. Thus, the COM tries to operate real time, whereas the (large) result has to be processed by Windows (VFP) at the same time. This might come to the output of the COM being approached as a serial process, whereas in the normal situation most of all would go parallel (the server providing the result records, the PC writing them into the cursor in the mean time).

HTH,
Peter

>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,