>>>Is it possible to access and store the actual query time from a VFP SQL query?
>>>
>>Sure,
>
>Be careful analyzing results if you are designing for a slow network--you may get very different results between your first and second query. VFP is very good at keeping index information once it has loaded it. Even exiting VFP doesn't clear the info.
>
>For example, on a particular view I was recently testing, the first time I use the view over a 33k modem connection it takes 60 seconds. The second time is 2 seconds.
Thanks for the reminder. I will be logging query results over time so I should be able to interpret it.
Bill
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.