>>>Have you tried doing a pseudo query upon startup?
>>>For example, doing a query to return just 1 record or using NODATA parameter.
>>
>>The form opens with the view's NoDataOnLoad = .T., 0 record in less than a second. It's the first requery that takes too long.
>
>Does it take a long time if you specify just 1 record to return ?
Actually the culprit was incorrect index tags. I fixed the WHERE clause and the index tags for Rushmore optimization.
Thanks for your help. :)
Thanks!
~d
J