I have a query in my FXP that is taking an unusually long time to execute.

 

I turned on the coverage profiler and the query appears to be taking 44 seconds to execute.

 

When I do the same query in the command box from the VFP IDE it takes 1 second to execute.

 

It is a simple query of one table with index tags existing for both fields in the where clause.

 

Is there any reason why it should take longer from an FPW script then from the command box?

 

Also, If I want to use the coverage profiler application I assume it would be necessary to turn on the option to "keep the prg files"? Is that correct?

 

Thanks,

Jeff