Try to see how much memory you have available in the app and limit the amount of memory that VFP can use in prg to the same amount. I believe it depends on the difference between the available amounts. If there's no big diff., probably this is not the cause.

Vlad

>Perhaps, but I'm not sure... Honestly, I doubt that less amount of memory
>can cause such slow down of the speed. Really, it causes approximately two
>times difference in speed. Very strange.... I tried to open the table (100
>megabytes in size) 20 times and then ran the query from prg, but the
>results was the same (more speed when it runs from prg).