From an EXE standpoint 10 seconds is not too bad considering that your machine has to hit the exe, check security rights for you for loading the EXE, get the fox runtime loaded, look for the location of xxx, probably looking down some sort of path, check security rights on xxx, get it loaded, look and see what your temp file read write settings and rights are, then begin to create the table as an output.

A couple of suggestions for the EXE. Right to a cursor if possible. Make sure you have a config.fpw for the exe (config.fp if this is a dos app. Set all 4 temp file settings to a local folder instead of a server folder.

They are:
TmpFiles = c:\temp\myapp
SortWork = c:\temp\myapp
EditWork = c:\temp\myapp
ProgWork = c:\temp\myapp

>Hi!
>I wrote a simple prg:
>select * from xxx into table yyy
>It runs from command line very fast, selects 5.000 records under 1 sec.
>Then I make an application from this prg .and. it selects the same records but
>10 times slowly , and if I make an exe It runs more slowly. What can I do?
>SET TALK OFF didn't help.
>Help me!
> András